Is possible to reuse a already calculatesd column into a query in MySQL? I have a query with complicated column, and I would like to use this column result in another column, for instance:

SELECT ( /* Complex query */ ) as myValue, if( myValue &gt; 10, "OK" , "" ) from table;


but his query returns an error:

Error Code: 1054. Unknown column 'myValue' in 'field list


How can I reuse a already calculated field?
You can use user-defined variable.

SELECT @temp := ( /* Complex query */ ) AS myValue, 
       IF ( @temp &gt; 10, "OK" , "" )
FROM table;


Maybe server demands preliminary variable definition. If so,

SELECT @temp := ( /* Complex query */ ) AS myValue, 
       IF ( @temp &gt; 10, "OK" , "" )
FROM table, (SELECT @temp := 0) dummy;


The documentation do not specified the order of output values calculations, but in practice it always matched the order they are written.