SOUNDEX(str)

MySQL 8.4

Returns a soundex string from str, or NULL if str is NULL. 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 nonalphabetic characters in str are ignored. All international alphabetic characters outside the A-Z range are treated as vowels.

Syntax

MYSQL

SELECT SOUNDEX('Hello');
'H400'
SELECT SOUNDEX('Quadratically');
'Q36324'

Examples

Example

When using SOUNDEX(), you should be aware of the following limitations:

MYSQL

SELECT SOUNDEX('Hello');
'H400'
SELECT SOUNDEX('Quadratically');
'Q36324'