MySQL SOUNDS LIKE Operator

MySQL SOUNDS LIKE operator is used as SOUNDEX(expr) = SOUNDEX(expr) to retrieve result sounds similar.

Note: It does not support the % wildcard.

MySQL SOUNDS LIKE OPERATOR Syntax

To search a record that result sounds similar, use the following syntax:

SELECT col1, col2, ...
FROM tablename
WHERE colN SOUNDS LIKE pattern;

Parameters:

tablename: The table name from which you want to fetch the records.

pattern: To perform pattern matching search in a column.

The following MySQL statement is used to search a value that sounds similar:

SELECT firstName, lastName, address FROM tblCustomerLoan
WHERE firstName SOUNDS LIKE 'delep';

Note:

In the above example, we are showing how to use the SOUNDS LIKE operator search a record that result sounds similar.

You can use MySQL Command Line Client to search a record search a record that result sounds similar. It will look like this: