What is the use of MySQL SOUNDS LIKE operator?

As the name suggests, MySQL SOUNDS LIKE operator will search the similar sound values from a table. Its syntax is ‘Expression1 SOUNDS LIKE Expression2’ where, both Expression1 and Expression2 will be compared based on their English pronunciation of sound.

Example

Following is an example from ‘student_info’ table which will match the two expressions based on the pronunciation of sound −

mysql> Select * from student_info where name sounds like 'grov';
+------+--------+---------+------------+
| id   | Name   | Address | Subject    |
+------+--------+---------+------------+
| 105  | Gaurav | Jaipur  | Literature |
+------+--------+---------+------------+
1 row in set (0.00 sec)

mysql> Select * from student_info where name sounds like 'rmn';
+------+-------+---------+-----------+
| id   | Name  | Address | Subject   |
+------+-------+---------+-----------+
| 125  | Raman | Shimla  | Computers |
+------+-------+---------+-----------+
1 row in set (0.00 sec)

Kumar Varma

Published on 21-Feb-2018 11:40:34

• Related Questions & Answers
• What is the use of SOUNDS LIKE operator in MySQL?
• What is the use of MySQL NOT LIKE operator?
• What is the use of RLIKE operator in MySQL?
• Explain the use of sql LIKE operator using MySQL in Python?
• What is the use of MySQL IS and IS NOT operator?
• What is the significant difference between MySQL LIKE and equal to (=) operator?
• What is the use of sizeof Operator in C#?
• What is the use of tilde operator (~) in R?
• What is the use of EXIST and EXIST NOT operator with MySQL subqueries?
• What is the use of scope resolution operator in C++?
• How to use MySQL SOUNDEX() function with LIKE operator to retrieve the records from table?
• What is the use of MySQL FROM_UNIXTIME() function?
• What is the use of MySQL GET_FORMAT() function?
• What is the use of NCHAR in MySQL?
• What is the use of MySQL LAST_INSERT_ID() function?