looking to shorten a query by referencing a formula

[slushpuppie]

i have a query that is similar to this (only much more complex so i won't bother writing it out):

 

SELECT `one`, `two`, (`three` + `four`)

FROM `table`

WHERE (`three` + `four`) < 25

 

is there a way i can set (`three` + `four`) to something, so that i can only reference it like:

 

SELECT `one`, `two`, (`three` + `four`) AS `XXX`

FROM `table`

WHERE XXX < 25

 

(i know the above doesn't work, but i'm looking for something similar to it, where i can write out the equation once and then reference it).

[Mchl]

Not really. Aliases are forbidden in WHERE clause, and there's no other means of doing it (AFAIK). You might however want to create a view with (`three` + `four`) being a separate column.