update: It's been a little while, and I don't recall where I got the idea that LIMIT 1 LIMIT 2 is valid syntaxt, but it's not. I'll chalk this up to sleeplesness.
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.
