All pages
Powered by GitBook
1 of 1

Loading...

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

This page is licensed: GPLv2, originally from

SELECT givenname, surname FROM users WHERE givenname SOUNDS LIKE "robert";
+-----------+---------+
| givenname | surname |
+-----------+---------+
| Roberto   | Castro  |
+-----------+---------+
fill_help_tables.sql