[PHP] MySQL fulltext indices and phrase search
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
[EMAIL PROTECTED]
http://www.rosomm-partner.de
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MySQL fulltext indices and phrase search
Jens Kisters [EMAIL PROTECTED] wrote:
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%'
Perhaps you should ask on the mysql list.
List-Subscribe: mailto:[EMAIL PROTECTED]
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
