SQL syntax error using sort

[timski72]

Hello,

I wonder if someone could tell me what is wrong with the following syntax:

select videoid from videos order by videoid desc where videoname = "the_men_are_cleaning_the_cars"

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where videoname = "the_men_are_cleaning_the_cars" LIMIT 0, 30' at line 1

If I leave out the "order by desc" the query works fine.

I am using MySql version 5.1.36.

Any advice would be appreciated.
Thanks,
Tim.

[NogDog]

The WHERE clause must come before the ORDER BY clause.

[timski72]

Ah of course. Thanks NogDog.