Re: Liberating Dependent Subqueries

[mnf]

Ok, I was just saying that example from original post by Shlomo Swidler doesn't work "as is":
--- quote ---
Well, I don’t have a "constify" function (more on this below), but I do have a "constify" stored procedure, which lets me do as follows:

mysql> call constify("SELECT tag_id FROM tags WHERE LOCATE('bunk', tag_text)>0", @result);
mysql> DELETE FROM book_tags WHERE tag_id IN ( @result );
--- end of quote ---