SQL question

[Anon]

Hi 🙂

i have an

select ... from ... where EXPRESSION order by EXPRESSION

The expressíon is quite long... how could i make an alias for this expression? i don't want to write this twice, and i was wondering if i could do some alias

thank you! 🙂

[Anon]

select ... from (select t.*, expression as e
from t ) as s
where s.e = 4711 order by s.e

Will not (of course) work in Mysql

[Anon]

or just make EXPRESSION a php variable. (this sql is in a php script right?)