顧名思義,MySQL SOUNDS LIKE 運算符將從表中搜索相似的聲音值。其語法為“Expression1 SOUNDS LIKE Expression2”,其中,Expression1 和 Expression2 將根據(jù)其聲音的英語發(fā)音進行比較。
示例
以下是“student_info”表中的一個示例,它將根據(jù)聲音的發(fā)音匹配兩個表達式 –
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 運算符有什么用?的詳細內(nèi)容,更多請關注www.92cms.cn其它相關文章!