Re: Best way to simulate a "join" and "limit" during DELETE

[Peter Brawley]

All three ought to work. Semi-joins like IN() are better optimised in more recent versions, so something like ...

set @id = ( select id from ... where name='Bob'
delete from ... where id=@id;

... or ...

delete from posts where postid = (select userid from users where username='bob');

... or several such variations.

If you're unsure, first run the corresponding SELECT first to verify that you have the scope right.