SOUNDS LIKE

Compare strings by sound. This operator tests if two strings have the same Soundex value, useful for fuzzy matching.

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  |
+-----------+---------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}