MySQL的SOUNDS LIKE运算符有什么用处？

正如其名，MySQL的SOUNDS LIKE运算符将从表中搜索类似的语音值。其语法是“Expression1 SOUNDS LIKE Expression2”，其中Expression1和Expression2将基于它们的英语发音进行比较。

阅读更多：MySQL 教程

例子

下面是一个来自“student_info”表的例子，它将基于声音的发音匹配两个表达式-

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)