Lalkhum Sanga

Actually, it is working if I drop "drop" bit from the query. @cvogt It would really be cool if you guys could support this. :) Thanks

@cvogt, it would something like: ``` create view temp_cv as select version from MyTable where status='archived' order by last_modified desc limit 1; delete from MyTable where status='archived' and version not...

I was trying to run the query that you have given above, and I got the following error, ``` This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'...