Re: soundex question
| From: | Alan McFarlane | Date: | Thu, 17 Apr 2003 18:06:33 +0000 |
| Subject: | Re: soundex question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-144335@lists.php.net to get a copy of this message | ||
At a rough guess, I suspect you would have to create a lookup table, or
perhaps replace '.' with '*' and do a search for 'looks like' /
'similar'
(Can't remember the exact SQL syntax)
"Daniel" <daniel@electroteque.org> wrote in message
news:3E9905C7@node18.shanje.com...
> hi there how is it possible to get similar matches of extries in mysql , i
> have a standard set of list of countries in the db , i am trying to
convert a
> set of records and need to match against the countries table to get the
> primaryID , basically i have an record like "Hong Kong" there is an entry
like
> "H.kong" i basically need to match those , i've tried everything even
soundex
> doesnt work :|
>
>