note 10395 added to soundex
| From: | rod dot taylor at inquent dot com | Date: | Mon, 01 Jan 2001 01:28:08 +0000 |
| Subject: | note 10395 added to soundex | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-9268@lists.php.net to get a copy of this message | ||
select * from soundex(table.column1) = (soundex('input value'::varchar))
is also optimized, and forces pre-processing for the static 'input value'. That is, it
will not calculate on a per row basis (the second half of the equation anyway). Most databases
should make that optimization anyway.
http://www.php.net/manual/function.soundex.php