[ale] delete rows in mysql

[Chris Fowler]

On Wed, 2010-05-05 at 10:26 -0400, James Sumners wrote:
> delete from trigger where trigger_id IN ((select trigger_id from
> trigger_group_map where trigger_group_id=3)) 

ERROR 1242 (21000): Subquery returns more than 1 row


To give a background, about every problem I solve I use perl as the
tool.  I'm thinking that for something like this SQL would be much
faster than writing a quickie perl script.