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.
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 search.
Hi,
We have an a auction like site, now we have to add a search feature to the
site, the searching will be done for 2 fields:
subject and description (ad_sub, ad_text).
Since i have never done this before, I would appreciate some advise on how
to do it.
I was thinking of getting the search
3 matches
Mail list logo