Try
SELECT * FROM sometable LIMIT 1 LIMIT 2;
That's supposed to be legal in mysql, as well as it's own custom equivalent
SELECT * FROM sometable LIMIT 2,1;
but mysql BARFS on the first one as illegal syntaxt.
I can't believe my eyes (got mysql4 alpha, and mysql3.2 something).
I'm getting 4.0 Gamma right now to try it there.