Sum some fields in a select query

[Darkmatter5]

I have 3 fields in a table called allo_hp, allo_mp and allo_mp and I'm wanting to add up the numbers in each of those fields and have that sumed result aliased out as total.  How can I go about doing that?

[gevans]

You can do the following;

 

SELECT (`allo_hp` + `allo_mp` + `allo_theotherone`) as `total`
FROM `your_table`