Re: [PHP] mySQL WHERE/LIKE

2002-05-23 Thread Jason Wong
On Thursday 23 May 2002 22:20, Wilbert Enserink wrote: Hi all, I know this is rather OT, but I searched the mySQL manual all over...couldn't find it. Why not ask on the mysql list !?! I want to perform a search in a table. More then 1 columns should be searched. namely column1 and

Re: [PHP] mySQL WHERE/LIKE

2002-05-23 Thread Aaron Gould
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 * FROMgallery LEFT JOIN designers ON (designers.designersID=gallery.designersID) WHERE (gallery.column1 LIKE