mySQL Super-tip! Use LI...
Awesome, it seems that mySQL now supports the OFFSET clause.
This is very useful for paginating your SQL statements.
The following will return the first 10 entries of your select statement:
“SELECT field FROM table LIMIT 10″
This, on the otherhand, will OFFSET your result by 10, selecting your entries #10-20:
“SELECT field FROM table LIMIT 10 OFFSET 10″
Here’s an [...]
