Re: merge two statements

2001-06-03 Thread Patrick Goetz
On Sat, 2 Jun 2001, Jens Luedicke wrote: > I'm using MySQL through the Perl DBI and I want to merge > two SQL statements that would simplify my code: > > 1. SELECT * FROM filters WHERE folder != '$folder' > 2. SELECT * FROM mails WHERE folder_name = '$folder' AND x$filters->{type} LIKE >'%$filt

merge two statements

2001-06-02 Thread Jens Luedicke
hi there ... I'm using MySQL through the Perl DBI and I want to merge two SQL statements that would simplify my code: 1. SELECT * FROM filters WHERE folder != '$folder' 2. SELECT * FROM mails WHERE folder_name = '$folder' AND x$filters->{type} LIKE '%$filters->{pattern}%' for each of the resul