Re: Database search question
| From: | Kim Kohen | Date: | Sun, 31 Mar 2002 06:21:54 +0000 |
| Subject: | Re: Database search question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18073@lists.php.net to get a copy of this message | ||
G'day Chris
> I have 3 fields, city, country, type
> I also have an imput box where you can type in a search word. What I need is,
> say you type in hotels germany, I need the search to break up the sentence and
> then search each 3 fields in the DB looking for a match.
> So, for example: it would find hotels in type and germany in country, see that
> they belong together and then display those results - how can I do this?
I'm far from an expert but what you're describing sounds like a classic use
of the Match command and a multi-column full text index in mysql. Of course
I don't know if you're using mysql.
cheers
kim