Syntax
------ 
expr1 SOUNDS LIKE expr2
 
Description
----------- 
This is the same as SOUNDEX(expr1) = SOUNDEX(expr2).
 
Example
 
SELECT givenname, surname FROM users WHERE givenname SOUNDS
LIKE "robert";
 
+-----------+---------+
| givenname | surname |
+-----------+---------+
| Roberto | Castro |
+-----------+---------+
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/sounds-like/