Operators

AND BETWEEN BINARY CASE DIV IN IS IS NOT IS NOT NULL IS NULL LIKE NOT NOT BETWEEN NOT IN NOT LIKE NOT REGEXP OR REGEX RLIKE SOUNDS LIKE XOR

thumb_up

thumb_down

chat_bubble_outline
0
 auto_stories new 
settings

MySQL | SOUNDS LIKE

Database

MySQL

Documentation

Operators

Jul 1, 2022

Last updated

local_offer MySQL

Syntax


        
        
            
                
                
                    -- This is equivalent to SOUNDEX(expr1) = SOUNDEX(expr2)
SELECT expr1 SOUNDS LIKE expr2;

Examples

Basic usage

To check whether 'sea' sounds like 'see':


        
        
            
                
                
                    SELECT 'sea' SOUNDS LIKE 'see';
                
            
            +-------------------------+
| 'sea' SOUNDS LIKE 'see' |
+-------------------------+
|                       1 |
+-------------------------+

We can verify the above with the below:


        
        
            
                
                
                    SELECT SOUNDEX('sea') = SOUNDEX('see');
                
            
            +---------------------------------+
| SOUNDEX('sea') = SOUNDEX('see') |
+---------------------------------+
|                               1 |
+---------------------------------+

To check whether 'listen' sounds like 'listener':


        
        
            
                
                
                    SELECT 'listen' SOUNDS LIKE 'listener';
                
            
            +---------------------------------+
| 'listen' SOUNDS LIKE 'listener' |
+---------------------------------+
|                               0 |
+---------------------------------+