Sort by query-defined rows

[simenss]

Hi,

 

I want to check the value of a row in a MySQL-query that's defined just in the query. I thought of something like this:

 

SELECT table.my_row AS `new_row`
FROM `table`
WHERE `new_row` = 'YES'

 

But it doesn't work. I only get the error #1054 - Unknown column 'new_row' in 'where clause'. How do I check the value of a row that's defined just in the query (in this case) `new_row`? 

 

My MySQL client version is 5.0.37.

[Illusion]

remove backsticks on new_row and try.

[fenway]

remove backsticks on new_row and try.

 

That's right, don't escape your alias!