Re: delete with an offset?

[Eric Persson]

Dobromir Velev wrote:
delete from where to_uid=1 and read_timestamp>0 and timestamp<(select 
timestamp from messages  where to_uid=1 and read_timestamp>0 order by 
timestamp desc limit 100,1)

HTH

Thanks for your answer, I guess i'll have to do with two queries, but it 
looked like such and idea that someone might have thought about it 
before. ;)

thanks,
        Eric

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