The SOUNDEX SQL Function in MySQL and MariaDB - Soundex string |
|
| | SOUNDEX | Syntax: | SOUNDEX(String) | | Return value: | CHAR | | Function type: | String function | |
| | The SOUNDEX() function returns a soundex string of "String".
By default, a soundex string has a length of four characters. However, the SOUNDEX() function returns a string of any length. The result can be truncated to get a standard soundex string.
All non-alphabetic characters in "String" are ignored.
All international alphabetic characters outside of the A-Z range are treated as vowels.
If "String" is empty or contains no valid characters, an empty string is returned.
If the value of "String" is NULL, the SOUNDEX() function returns NULL.
This function only works well in English.
Strings in other languages may produce poor results. | SQL Examples for the SOUNDEX function |
| select soundex('Test');
select soundex('Hello');
select soundex('Hello, this is a Test');
select soundex('');
select soundex('123456');
select soundex(123456);
select soundex(null);
|
|
| soundex('Test') |
|---|
| varchar(4) BINARY |
|---|
| T230 |
|
|
| soundex('Hello') |
|---|
| varchar(5) BINARY |
|---|
| H400 |
|
|
| soundex('Hello, this is a Test') |
|---|
| varchar(21) BINARY |
|---|
| H432323 |
|
|
| soundex('') |
|---|
| varchar(4) BINARY |
|---|
| |
|
|
| soundex('123456') |
|---|
| varchar(6) BINARY |
|---|
| |
|
|
| soundex(123456) |
|---|
| varchar(6) BINARY |
|---|
| |
|
|
| soundex(null) |
|---|
| varchar(4) BINARY |
|---|
| NULL |
|
|
| | The examples were created with the MyWAY SQL manager: | How to use the SOUNDEX() function in MySQL and MariaDB databases | | In MySQL and MariaDB, the SOUNDEX() function is used to convert a string into a four-digit code, which represents their pronunciation. It is primarily used for phonetic matches based on the pronunciation of words rather than their actual spelling. The SOUNDEX() function is useful when a phonetic search needs to be performed. This makes it possible to find similar-sounding words even if they have different spellings. However, it is important to note that SOUNDEX() is a simple algorithm and may not be suitable for all cases or languages. | | Further MySQL und MariaDB SQL String functions | | CHAR | CHAR(Character code, [, Charset]) | | More about CHAR Function |
| | CHR | CHR(Character code) | | More about CHR Function |
| | CONCAT | CONCAT(Strings ('str1','str2', ...)) | | More about CONCAT Function |
| | CONCAT_WS | CONCAT_WS(Separator, Strings ('str1','str2', ...)) | | More about CONCAT_WS Function |
| | ELT | ELT(Index, Strings ('str1','str2', ...)) | | More about ELT Function |
| | EXPORT_SET | EXPORT_SET(Bits, On, Off [, Separator] [, Number of bits]) | | More about EXPORT_SET Function |
| | EXTRACTVALUE | EXTRACTVALUE(XML, XPath) |
| | FIELD | FIELD(Search string, Strings ('str1','str2', ...)) | | More about FIELD Function |
| | FORMAT | FORMAT(Number, Decimals [, Region]) | | More about FORMAT Function |
| | INSERT | INSERT(String, Position, Length, String to insert) | | More about INSERT Function |
| | LCASE | LCASE(String) | | More about LCASE Function |
| | LEFT | LEFT(String, Length) | | More about LEFT Function |
| | LOAD_FILE | LOAD_FILE(File name) |
| | LOWER | LOWER(String) | | More about LOWER Function |
| | LPAD | LPAD(String, Length, String to append) | | More about LPAD Function |
| | LPAD_ORACLE | LPAD_ORACLE(String, Length, String to append) | | More about LPAD_ORACLE Function |
| | LTRIM | LTRIM(String) | | More about LTRIM Function |
| | MAKE_SET | MAKE_SET(Bits, Strings ('str1','str2', ...)) | | More about MAKE_SET Function |
| | MID | MID(String, Position [, Length]) | | More about MID Function |
| | QUOTE | QUOTE(String) | | More about QUOTE Function |
| | REPEAT | REPEAT(String, Number) | | More about REPEAT Function |
| | REPLACE | REPLACE(String, Search, Replace) | | More about REPLACE Function |
| | REVERSE | REVERSE(String) | | More about REVERSE Function |
| | RIGHT | RIGHT(String, Length) | | More about RIGHT Function |
| | RPAD | RPAD(String, Length, String to append) | | More about RPAD Function |
| | RPAD_ORACLE | RPAD_ORACLE(String, Length, String to append) | | More about RPAD_ORACLE Function |
| | RTRIM | RTRIM(String) | | More about RTRIM Function |
| | SPACE | SPACE(Number) | | More about SPACE Function |
| | SUBSTR | SUBSTR(String, Position, Length) | | More about SUBSTR Function |
| | SUBSTRING | SUBSTRING(String, Position, Length) | | More about SUBSTRING Function |
| | SUBSTRING_INDEX | SUBSTRING_INDEX(String, Delimiter, Number) | | More about SUBSTRING_INDEX Function |
| | TRIM | TRIM([Type] [, Delete character], , String) | | More about TRIM Function |
| | TRIM_ORACLE | TRIM_ORACLE([Type] [, Delete character], , String) | | More about TRIM_ORACLE Function |
| | UCASE | UCASE(String) | | More about UCASE Function |
| | UPPER | UPPER(String) | | More about UPPER Function |
| | WEIGHT_STRING | WEIGHT_STRING(String [AS Format] [LEVEL Level] [Sorting]) | | More about WEIGHT_STRING Function |
| | ASCII | ASCII(String) | | More about ASCII Function |
| | BIT_LENGTH | BIT_LENGTH(String) | | More about BIT_LENGTH Function |
| | CHAR_LENGTH | CHAR_LENGTH(String) | | More about CHAR_LENGTH Function |
| | CHARACTER_LENGTH | CHARACTER_LENGTH(String) | | More about CHARACTER_LENGTH Function |
| | FIND_IN_SET | FIND_IN_SET(Search string, Set of values) | | More about FIND_IN_SET Function |
| | INSTR | INSTR(String, Search string) | | More about INSTR Function |
| | LENGTH | LENGTH(String) | | More about LENGTH Function |
| | LENGTHB | LENGTHB(String) | | More about LENGTHB Function |
| | LOCATE | LOCATE(Search string, String [, Position]) | | More about LOCATE Function |
| | OCTET_LENGTH | OCTET_LENGTH(String) | | More about OCTET_LENGTH Function |
| | ORD | ORD(String) | | More about ORD Function |
| | POSITION | POSITION(Search string IN String) | | More about POSITION Function |
|
|
| | | More information about the SOUNDEX SQL function: and |
|
|
|
|
