Hi guys, I know about the LIMIT feature of MySQL to get only the first x number of results, but what if I want to get results 10-20, 20-50, etc... Reason I need it: When people search for stuff on my site, I want to only return first 20 results, then they can choose to get more results. I don't want to fetch more data than necessary, these queries are going to be very big. Thanks, -Tony
the syntax is: [LIMIT {[offset,] row_count | row_count OFFSET offset}] so if you want to start at 20 and get the next 20 you have limit 20, 20 if you want to start at 60 and get the next 20 it's limit 60, 20