Re: How to achieve "accent-insensitive" searching
Christoffer Vig <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
Have you tried the soundex function? |SOUNDEX(/|str|/)| Returns a soundex string from /|str|/. Two strings that sound almost the same should have identical soundex strings. A standard soundex string is four characters long, but the |SOUNDEX()| function returns an arbitrarily long string. You can use |SUBSTRING()| on the result to get a standard soundex string. All non-alphabetic characters are ignored in the given string. All international alphabetic characters outside the A-Z range are treated as vowels. http://dev.mysql.com/doc/mysql/en/string-functions.html Christoffer -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]