The only way I know how to do it is by doing boolean OR's...  It's not 
as compact and efficient as you'd like, but it works.

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

Wilbert Enserink wrote:
 > 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
 > -------------------------

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to