Re: [PHP] multiple words search query advise

2005-03-21 Thread Ryan A
Hey! Thanks! I'll look it up. -Ryan On 3/21/2005 5:53:38 AM, Brent Baisley ([EMAIL PROTECTED]) wrote: > You want to use a full text index spanning the two fields. You > wouldn't > want to do a "LIKE" search because that wouldn't be able to use > > > indexes, resulting in a full table scan every

Re: [PHP] multiple words search query advise

2005-03-21 Thread Brent Baisley
You want to use a full text index spanning the two fields. You wouldn't want to do a "LIKE" search because that wouldn't be able to use indexes, resulting in a full table scan every search. If you are using MySQL, you search read the part of the manual on creating and using full text indexes. It