Mysql SOUNDEX
From w3cyberlearnings
Contents |
MySQL SOUNDEX Function
This function returns the soundex key of a string. The soundex key is the four characters length of a word that represent the English pronunciation of a word.
Syntax SOUNDEX
- word: a given word
SOUNDEX(word);
Example 1
mysql> SELECT SOUNDEX('woman');
+------------------+
| SOUNDEX('woman') |
+------------------+
| W500 |
+------------------+
1 row in set (0.00 sec)
Example 2
mysql> SELECT SOUNDEX('women');
+------------------+
| SOUNDEX('women') |
+------------------+
| W500 |
+------------------+
1 row in set (0.00 sec)
