Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001051

[PHP-DB] MySQL fulltext indices and phrase search From: Jens Kisters (newsletters <email protected>)
Date: 05/02/01

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 <email protected>
http://www.rosomm-partner.de

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>