Mysql like中文搜尋問題

鍦ㄥ仛 MySQL 鐨?Like 鏌ヨ鏄彂鐜頒腑鏂囨悳绱㈡€繪槸涓嶄簤姘旓紝浠庣綉涓婃壘鍒頒簡鍑犱釜瑙ｅ喅鏂規硶锛屽ぇ瀹跺彲浠ョ湅鐪嬶細

鏂規硶涓€ :

瑙ｅ喅鏂規硶鏄浜庡寘鍚腑鏂囩殑瀛楁鍔犱笂 "binary" 灞炴€э紝浣誇箣浣滀負浜岃繘鍒舵瘮杈冿紝渚嬪灏?"name char(10)" 鏀規垚 "namechar(10)binary"銆?

鏂規硶浜?:

濡傛灉浣犱嬌鐢ㄦ簮鐮佺紪璇?MySQL锛屽彲浠ョ紪璇?MySQL 鏃朵嬌鐢?--with--charset=gbk 鍙傛暟锛岃繖鏍?MySQL灏變細鐩存帴鏀寔涓枃鏌ユ壘鍜屾帓搴忎簡銆?

鏂規硶涓?:

鍙互浣跨敤 Mysql 鐨?locate 鍑芥暟鏉ュ垽鏂€備互涓婅堪闂涓轟緥 , 浣跨敤鏂規硶涓?:

SELECT * FROM table WHERE locate(' 鏉?,field) > 0;

鏂規硶鍥?:

鎶婃偍鐨?Select 璇彞鏀規垚杩欐牱 ,SELECT * FROM TABLE WHERE FIELDS LIKE BINARY'%FIND%' 鍗沖彲

闂鍑虹幇鐨勫師鍥犳槸 :

鍦?MySQL 涓紝杩涜涓枃鎺掑簭鍜屾煡鎵劇殑鏃跺€欙紝瀵規眽瀛楃殑鎺掑簭鍜屾煡鎵劇粨鏋滄槸閿欒鐨勩€傝繖绉嶆儏鍐靛湪 MySQL鐨勫緢澶氱増鏈腑閮藉瓨鍦ㄣ€傚鏋滆繖涓棶棰樹笉瑙ｅ喅锛岄偅涔?MySQL 灏嗘棤娉曞疄闄呭鐞嗕腑鏂囥€?

MySQL 鍦ㄦ煡璇㈠瓧绗︿覆鏃舵槸澶у皬鍐欎笉鏁忔劅鐨勶紝鍦ㄧ紪缁?MySQL 鏃朵竴鑸互 ISO-8859瀛楃闆嗕綔涓洪粯璁ょ殑瀛楃闆嗭紝鍥犳鍦ㄦ瘮杈冭繃绋嬩腑涓枃缂栫爜瀛楃澶у皬鍐欒漿鎹㈤€犳垚浜嗚繖绉嶇幇璞?

鎴戠敤鐨勭涓変釜鍔炴硶 select * from table_name where locate('鍏抽敭瀛?,`瀛楁鍚峘)>0;

LOCATE(substr,str)

杩斿洖瀛愪覆 substr 鍦ㄥ瓧绗︿覆 str 涓涓€娆″嚭鐜扮殑浣嶇疆銆傚鏋滃瓙涓?substr 鍦?str 涓笉瀛樺湪锛岃繑鍥炲€間負 0锛?

mysql> SELECT LOCATE(鈥檅ar鈥? 鈥榝oobarbar鈥?;

-> 4