note 28544 added to function.soundex
| From: | jr at rack1 dot php dot net | Date: | Thu, 16 Jan 2003 15:25:13 +0000 |
| Subject: | note 28544 added to function.soundex | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-42221@lists.php.net to get a copy of this message | ||
a workaround for the mysql/php differences in implementation of soundex is to do the soundex
comparison entirely within mysql.
for example:
$sql = "SELECT * FROM table WHERE substring(soundex(field), 1, 4) =
substring(soundex('".$wordsearch."'), 1, 4)";
--
http://www.php.net/manual/en/function.soundex.php
http://master.php.net/manage/user-notes.php?action=edit+28544
http://master.php.net/manage/user-notes.php?action=delete+28544
http://master.php.net/manage/user-notes.php?action=reject+28544