鍦⊿QL涓紝LIKE鏌ヨ榛樿鏄ぇ灏忓啓涓嶆晱鎰熺殑锛屽嵆涓嶅尯鍒嗗ぇ灏忓啓銆傝繖鎰忓懗鐫€鏃犺鏄ぇ鍐欒繕鏄皬鍐欏瓧姣嶏紝閮戒細琚涓虹浉鍚屻€傚鏋滈渶瑕佽繘琛屽ぇ灏忓啓鏁忔劅鐨凩IKE鏌ヨ锛屽彲浠ヤ娇鐢ㄧ壒瀹氱殑鎿嶄綔绗︽垨鍑芥暟鏉ュ疄鐜帮紝渚嬪浣跨敤BINARY鎿嶄綔绗︺€備緥濡傦細

SELECT * FROM table_name WHERE column_name LIKE BINARY 'search_term';

杩欐牱灏卞彲浠ュ疄鐜板ぇ灏忓啓鏁忔劅鐨凩IKE鏌ヨ銆備笉杩囬渶瑕佹敞鎰忕殑鏄紝鏁版嵁搴撶郴缁熷彲鑳戒細鏈変笉鍚岀殑瀹炵幇鏂瑰紡鍜岃娉曪紝鍏蜂綋鎿嶄綔鏂瑰紡鍙兘浼氭湁鎵€涓嶅悓銆傚缓璁煡闃呯浉搴旀暟鎹簱绯荤粺鐨勬枃妗ｄ互鑾峰彇鏇村噯纭殑淇℃伅銆?/p>