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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]