sql语法中WHERE子句的位置

Question

I have generated an sql to query a database table where posts from users are saved.But I am getting error executing it.I have tested it here , It also tells me that it is incorrect and the problem lies in users_user_id section.I can't figure out what might be wrong here.Can any one help me with this error.

My userpost table structure is following:

post_id,post,title,users_user_id

sql:

SELECT title FROM userpost LIMIT 5 OFFSET 10 WHERE users_user_id=9

Answer 1

LIMIT always come after all keywords.

Corrected SQL:

SELECT title FROM userpost WHERE users_user_id=9 LIMIT 5 OFFSET 10

Generally, SELECT query has following sequence:

SELECT
Fields List
FROM
WHERE 
GROUP BY (if needed)
ORDER BY (if needed)
LIMIT (This always come at end and if limit is not specified, 
query will return all records from result set.)