MySQL Limit

You know the MySQL query limit thing we all use to only show the first few results of a query? You know, limit 0,5 to show the first 5 items. Simple.

But what if you want the next 5 items? limit 5,5. What the…

It’s simple really, you start the selection at the 5th item, then get the 5 items after it, so 6,7,8,9,10.

I didn’t know this, I had to read up on it. We all learn something new every day. It does show that even us developers who do this stuff every day miss the simple things, but it’s the simple things that make life easy.