i kill you scum

It's going to be a great day when it's 8:05 and I already want to kill someone.

The following query will emulate a

SELECT emp_id,lname,fname FROM employee LIMIT 20,10

That says, give me 10 records starting at record 21. So what will be returned are rows 21-30. This is used heavily in web-based apps so you can do recordset paging.

No no no no no no no NO NO NO NO NO NO NO NO NO NO!!!

This is NOT HOW RELATIONAL DATABASES WORK. There is NO guarantee AT ALL that you will get the rows back that you're expecting. Unless stupid ass MySQL actually does this, in which case it's even a worse, shittier database system than I realized. (and honestly, any db that doesn't support stored procs is already pretty low in my book.)