Q:

Syntax error near "ORDER BY order DESC" in MySQL?

Why I try to do an order by query, I always get an error telling me to check the syntax by the ORDER BY 'order' DESC.... Here's my query: 
SELECT * FROM posts ORDER BY order DESC;

What am I doing wrong??

A:

order is a reserved word in SQL; case does not matter. It must be quoted when used as an identifier. From the MySQL Reserved Words documentation:

Certain words such as SELECT, DELETE, or BIGINT [or ORDER] are reserved and require special treatment for use as identifiers such as table and column names.

Traditional MySQL quotes:
SELECT * FROM posts ORDER BY `order` DESC;

Proper (ANSI) SQL quotes (some databases support [order] as well):
SELECT * FROM posts ORDER BY "order" DESC;

Although I would consider renaming the column to avoid such confusing issues in the future.
Happy coding!

