顧名思義，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中文網其他相關文章！
