[RESOLVED] SQL - skip first row

[solitario]

Hello all.
I'm using PHP & MySQL. The following works, but I would like to skip the first row.

$sql = mysql_query('SELECT time_id FROM posts WHERE thread_id=1');

Any help is appreciated.
Many thanks.

[Brandoe85]

You can use the limit clause:

To retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter. This statement retrieves all rows from the 96th row to the last:

mysql> SELECT * FROM table LIMIT 95,18446744073709551615;

You could change yours to start at 1 instead of 95.
Link to that information

[solitario]

Excellent, thank you!