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

PHP Database 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]

Reply via email to