MySQL fulltext indices and phrase search
| From: | Jens Kisters | Date: | Wed, 02 May 2001 18:13:26 +0000 |
| Subject: | MySQL fulltext indices and phrase search | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-general+get-51181@lists.php.net to get a copy of this message | ||
Hi there, is there a possibility to use MySQL's MATCH ... AGAINST to
look for a string like "foo bar" ?
if i MATCH keyname AGAINST ('foo bar') i get resuts that match foo or
bar, but not both of them separated by a space.
My guess is that the organization of the index doesn't allow this kind
of search as it's based on single words , but maybe one of you has a
better idea than
to select the rows that contain both and hit those with LIKE '%foo bar%'
--
Grüße aus dem schönen Kleve
Jens Kisters
rosomm et partner
Agentur für neue Medien GmbH
Dienstleistungszentrum am
Weißen Tor - Eingang B
Gocher Landstrasse 2
47551 Kleve / Bedburg-Hau
Telefon: 02821 - 97856-20
Telefax: 02821 - 97856-77
j.kisters@rosomm-partner.de
http://www.rosomm-partner.de