SELECT ALL entries, but not the last 10 recent entries.

[jasonc]

how do i select all but the last recent 10 entries from a table.

 

SELECT * FROM `table` WHERE `user` = 'username' ORDER BY `date`

 

 

[Mchl]

First select last 10, then remove them from resultset

 

SELECT * FROM `table`AS t1
LEFT JOIN 
(SELECT ID FROM `table` WHERE `user` = 'username' ORDER BY `date` DESC LIMIT 10) AS t2
ON t1.ID = t2.ID
WHERE t2.ID IS NULL AND `user` = 'username' ORDER BY `date`

[F1Fan]

Another option (untested):

 

SELECT * FROM `table` WHERE `user` = 'username' ORDER BY `date` LIMIT ((SELECT count(*) FROM `table` WHERE `user` = 'username') - 10)

[Ken2k7]

Another option (untested):

 

SELECT * FROM `table` WHERE `user` = 'username' ORDER BY `date` LIMIT ((SELECT count(*) FROM `table` WHERE `user` = 'username') - 10)

I doubt that will work.

[Mchl]

I doubt that will work.

 

And rightly to do so.