:: Syntax Error

[anevins]

I've got a syntax error with my sql query and I don't know the correct structure.

 

I want to select all from a table 'rating' where the column 'check' is equal to the value 'checked', and I want to order it by the id descending, with a limit of 3.

 

This is the wrong syntax:

SELECT * FROM rating WHERE check='checked' ORDER BY rating_id DESC LIMIT 3

 

Any ideas on the right syntax?

[kickstart]

Hi

 

Check is a reserved word, so either change the column name (my preferred solution) or surround it with back tics.

 

SELECT * FROM rating WHERE `check`='checked' ORDER BY rating_id DESC LIMIT 3 

 

All the best

 

Keith

[anevins]

SOLVED

 

Thanks Kickstart

[Maq]

FYI, here's the list:

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html