[PHP] Metaphone, Soundex , MySQL

[bill]

greetings everyone,

is anyone using the soundex or metaphone functions to keyword match
multi-word (TEXT type) database fields? if so, i really could use some
pointers.

i have found that MySQL's SOUNDEX() function will make one gigantic value
from the entire paragraph, but that doesn't to me any good when searching
for words within the paragraph.

i have thought about just returning all the rows from the database and
doing the metaphone matching in php, but that doesn't seem right at all.

also considered metaphone encoding (in php) the data on entry into a
separate column and searching that column for metphone matches, then using
the id to get the human-readable data on a match.

i like the last one (and prefer metaphone), but am wondering what others
might be doing.

thanks kindly,
Bill

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general...@lists.php.net
For additional commands, e-mail: php-gene...@lists.php.net
To contact the list administrators, e-mail: php-lis...@lists.php.net