Understanding LIMIT? Can someone explain why the query below doesn't do as I hoped it would
do...return the ten records proceeding the row with an id of 200744?
Please note that id is not an auto increment and can jump from 200744
to 200801.
SELECT * FROM weeknumber WHERE id > 200744 ORDER BY id LIMIT 0,10
Many thanks,
Chris |