Hi,

Is it possible to delete from a table with some sort of offset? I did the following select query, which selects a message from a message table.

select id, subject from messages where to_uid=1 and read_timestamp>0 order by timestamp desc limit 3,1;

The reason is I only want it to be 3 messages per to_uid, so id thought I would be able to delete from the third message and forward with something like.

delete from messages where to_uid=1 and read_timestamp>0 order by timestamp desc limit 3,1000;

What I basically want is it to delete all messages above 100 for each user, any clues on how to solve this?

Best regards,
        Eric

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to