RE: FN-FORUM: Mysql syntax help

date posted 1st May 2008 16:16

>> >
>> > is there a way to order them whilst omitting the single most recent
>> > entry ie
>> >
>> > 2,3,4 rather than 1,2,3
>> >
>>

Look at the limit clause limit 1,3 will return 3 rows after the offset (1
in this case)

So you need

SELECT * FROM albumlist ORDER BY id DESC limit 1,3;


Note that that's a mysqlism, postgress has it the other way round limit
3,1 and SQLServer is just too weird for me to get along with ;-)

HTH

D