Start for mysql Query PHP

Question

Hi,

I'm currently looking to have a mysql query retrieve data and have and a start and limit.

So like, select * from table where x = x START AT ID X LIMIT X

thanks :)

Answer 1

SELECT * FROM table
WHERE x = x
ORDER BY ID
LIMIT x, x

Answer 2

SELECT * FROM `tableName` WHERE `colName`='someVal' LIMIT 0, 10 

The first limit value is the starting record number. The second value is the number of records to query.

Answer 3

You're looking for LIMIT:

SELECT * FROM tbl LIMIT 5,10;  # Retrieve rows 6-15