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

The return value of 0 indicates that the two strings do not sound alike.

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

Official MySQL Documentation

https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#operator_sounds-like

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!