expr1 SOUNDS LIKE expr2
This is the same as SOUNDEX(expr1) = SOUNDEX(expr2)
.
SELECT givenname, surname FROM users WHERE givenname SOUNDS LIKE "robert"; +-----------+---------+ | givenname | surname | +-----------+---------+ | Roberto | Castro | +-----------+---------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/sounds-like/