From: "Adam Williams" <awilliam@xxxxxxxxxxxxxxxx>
> CPT John W. Holmes wrote:
> > From: "Adam Williams" <awilliam@xxxxxxxxxxxxxxxx>
> >
> >>I am selecting a field in a database called description for keyword
> >>searching. The field contains names of people, states, years, etc.
When
> >>someone searches for say "holmes north carolina" the query searches for
> >>exactly that, fields which have "holmes north carolina", and not fields
> >>that contaim holmes, north, and carolina. So I run a str_replace to
> >>replace all spaces with *, which turns it into "holmes*north*carolina",
> >>but say that north carolina is before holmes in the field, it won't
return
> >>those fields (it only returns fields in which holmes is infront of north
> >>carolina). So how can I have it return all fields which contain all
> >>the words holmes, north, and carolina in any order, in that field?
> >
> > Are you doing a fulltext search or just matching a word in a lookup
column?
>
> I'm doing a fulltext search.
What is your query? Assuming MySQL, I get a result like this:
mysql> select * from test where match(t) against ('holmes north carolina');
+--------------------------------------------+
| t |
+--------------------------------------------+
| my name is john holmes from north carolina |
| i'm from the north |
| in carolina is my home |
| did I mention my last name is holmes? |
+--------------------------------------------+
4 rows in set (0.01 sec)
Isn't that what you want?
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
