Select last n records matching a query.

[StefIsScared]

I am trying to select the last n records in a database which conform to criteria selected by a user. I gather that there is no "BOTTOM" equivalent to the "SELECT TOP" command. I've tried "SELECT... ORDER BY... LIMIT X,Y" but MySQL doesn't seem to take a second parameter for the LIMIT statement. Is there any way round this?

 

[ericbrunson]

It does take a second parameter to limit, by why not reverse your 'order by' and take the first n records?

 

[StefIsScared]

I've just tried "SELECT * FROM events ORDER BY event_id DESC LIMIT 10" which I think is what you mean, and for some reason it's throwing up "run-time error '3138': syntax error in ORDER BY clause".