MySQL SOUNDS LIKE 運算子有什麼用？

顧名思義，MySQL SOUNDS LIKE 運算子將從表中搜尋類似的聲音值。其語法為“Expression1 SOUNDS LIKE Expression2”，其中，Expression1 和 Expression2 將根據其聲音的英語發音進行比較。

範例

以下是「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)

以上是MySQL SOUNDS LIKE 運算子有什麼用？的詳細內容。更多資訊請關注PHP中文網其他相關文章！