MySQL fulltext indices and phrase search

From: 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

« previous php.general (#51181) next »