Grab all but last result

[gibigbig]

I would like to get every result from a table except the very last record.

 

example if a database has this structure:

ID

0

1

2

3

4

5

 

 

 

i only want the records from 0-4.

I want it to select all but the last record, this means that i cant know how many records there are since the records will keep increasing

[Pikachu2000]

Run a SELECT COUNT() query, then use the result in the LIMIT clause for the SELECT query.