how to limit the number of records mysql produces

there is a very simple method to limit the number of records mysql produce

at the end of your sql statement you simply add "LIMIT 100" where 100 is the number of records you wish to show.

if you want to start from a certain record you just add "LIMIT 30, 100"

where 30 is the record number you want to start from and 100 is the number of rows to show.

Trending right now