SOUNDEX()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the Soundex representation of a string.
USAGE
SOUNDEX(string)
Argument Name | Description |
|---|---|
| The string to transform |
DETAILS
SOUNDEX() is a string function that returns the Soundex string equivalent of the string argument.
A Soundex string will be the same for similar sounding words. As an example, the words "seas" and "sees" have the same return value.
A NULL is returned if the argument is NULL.
EXAMPLES
SELECT SOUNDEX('Seas'), SOUNDEX('sees');
+-----------------+-----------------+
| SOUNDEX('Seas') | SOUNDEX('sees') |
+-----------------+-----------------+
| S000 | S000 |
+-----------------+-----------------+
SELECT SOUNDEX('mariadb');
+--------------------+
| SOUNDEX('mariadb') |
+--------------------+
| M631 |
+--------------------+
SELECT SOUNDEX('Robert'), SOUNDEX('Rupert');
+-------------------+-------------------+
| SOUNDEX('Robert') | SOUNDEX('Rupert') |
+-------------------+-------------------+
| R163 | R163 |
+-------------------+-------------------+