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]