Hi all,

I know this is rather OT, but I searched the mySQL manual all over...couldn't find it.
I want to perform a search in a table. More then 1 columns should be searched. namely 
column1 and column2 and so on.
Anybody knows what goes wrong here? --(in the WHERE clause). It seems that mySQL 
doesn't like to perform a search in more then 1 column.:-(

$query="SELECT * FROM gallery LEFT JOIN designers ON 
(designers.designersID=gallery.designersID) WHERE (gallery.column1, gallery.column2) 
LIKE '%$search_string%' ORDER BY gallery.galleryID";

thx for any advice

Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852

Reply via email to