《MySQL模糊查询语法.doc》由会员分享，可在线阅读，更多相关《MySQL模糊查询语法.doc（6页珍藏版）》请在金锄头文库上搜索。
1、MySQL模糊查询语法MySQL妯硦鏌璇硶$sql=select * from table_name where field_name like %$var%; $result=mysql_query($sql) or die; MySQL鎻愪緵鏍囧噯鐨凷QL妯紡鍖归厤锛屼互鍙婁竴绉嶅熀浜庤薄Unix瀹炵敤绋嬪簭濡倂i銆乬rep鍜宻ed鐨勬墿灞曟鍒欒杈惧紡 妯紡鍖归厤鐨勬牸寮忋?SQL鐨勬寮忓尮閰嶅厑璁镐綘浣跨敤鈥淿鈥濆尮閰嶄换浣曞崟涓瓧绗紝鑰屸?鈥濆尮閰嶄换鎰忔暟鐩瓧绗?鍖呮嫭闆朵釜瀛楃)銆?鍦?MySQL涓紝SQL鐨勬寮忕己鐪佹槸蹇界暐澶皬鍐欑殑銆備笅闈樉绀轰竴浜涗緥瀛愩傛敞鎰忓湪浣犱娇鐢
2、QL妯紡鏃讹紝浣犱笉 鑳戒娇鐢?鎴?=锛涜屼娇鐢IKE鎴朜OT LIKE姣旇緝鎿嶄綔绗?涓轰簡鎵惧嚭浠渂鈥濆紑澶寸殑鍚嶅瓧锛?mysql SELECT * FROM pet WHERE name LIKE b%; +-+-+-+-+-+-+ | name | owner | species | sex | birth | death | +-+-+-+-+-+-+ | Buffy | Harold | dog | f | 1989-05-13 | NULL | | Bowser | Diane | dog | m | 1989-08-31 | 1995-07-29 | +-+-+-+-+-+-
3、+ 涓轰簡鎵惧嚭浠渇y鈥濈粨灏剧殑鍚嶅瓧锛?mysql SELECT * FROM pet WHERE name LIKE %fy; +-+-+-+-+-+-+ | name | owner | species | sex | birth | death | +-+-+-+-+-+-+ | Fluffy | Harold | cat | f | 1993-02-04 | NULL | | Buffy | Harold | dog | f | 1989-05-13 | NULL | +-+-+-+-+-+-+ 涓轰簡鎵惧嚭鍖呭惈涓涓渨鈥濈殑鍚嶅瓧锛?mysql SELECT * FROM pet
4、 WHERE name LIKE %w%; +-+-+-+-+-+-+ | name | owner | species | sex | birth | death | +-+-+-+-+-+-+ | Claws | Gwen | cat | m | 1994-03-17 | NULL | | Bowser | Diane | dog | m | 1989-08-31 | 1995-07-29 | | Whistler | Gwen | bird | NULL | 1997-12-09 | NULL | +-+-+-+-+-+-+ 涓轰簡鎵惧嚭鍖呭惈姝5涓瓧绗殑鍚嶅瓧锛屼娇鐢淿鈥濇寮忓瓧绗細
5、mysql SELECT * FROM pet WHERE name LIKE _; +-+-+-+-+-+-+ | name | owner | species | sex | birth | death | +-+-+-+-+-+-+ | Claws | Gwen | cat | m | 1994-03-17 | NULL | | Buffy | Harold | dog | f | 1989-05-13 | NULL | +-+-+-+-+-+-+ 鐢盡ySQL鎻愪緵鐨勬寮忓尮閰嶇殑鍏朵粬绫诲瀷鏄娇鐢墿灞曟鍒欒杈惧紡銆傚綋浣犲杩欑被妯紡杩涜鍖归厤娴嬭瘯鏃讹紝浣跨敤 REGEXP鍜孨OT
6、REGEXP鎿嶄綔绗?鎴朢LIKE鍜孨OT RLIKE锛屽畠浠槸鍚屼箟璇?銆?鎵睍姝垯琛揪寮忕殑涓浜涘瓧绗槸锛?鈥?鈥濆尮閰嶄换浣曞崟涓殑瀛楃銆?涓涓瓧绗被鈥淸.鈥濆尮閰嶅湪鏂规嫭鍙峰唴鐨勪换浣曞瓧绗備緥濡傦紝鈥淸abc鈥濆尮閰嶁渁鈥濄佲渂鈥濇垨鈥渃鈥濄?涓轰簡鍛藉悕瀛楃鐨勪竴涓寖鍥达紝浣跨敤涓涓?鈥濄傗淸a-z鈥濆尮閰嶄换浣曞皬鍐欏瓧姣嶏紝鑰屸淸0-9鈥濆尮閰嶄换 浣曟暟瀛椼?鈥?* 鈥濆尮閰嶉浂涓垨澶氫釜鍦畠鍓嶉潰鐨勪笢瑗裤備緥濡傦紝鈥渪*鈥濆尮閰嶄换浣曟暟閲忕殑鈥渪鈥濆瓧绗紝鈥淸0-9*鈥?鍖归厤鐨勪换浣曟暟閲忕殑鏁板瓧锛岃屸?*鈥濆尮閰嶄换浣曟暟閲忕殑浠讳綍涓滆銆?姝垯琛揪寮忔槸鍖哄垎
7、澶皬鍐欑殑锛屼絾鏄鏋滀綘甯屾湜锛屼綘鑳戒娇鐢竴涓瓧绗被鍖归厤涓鍐欐硶銆備緥濡傦紝 鈥淸aA鈥濆尮閰嶅皬鍐欐垨澶啓鐨勨渁鈥濊屸淸a-zA-Z鈥濆尮閰嶄袱绉嶅啓娉曠殑浠讳綍瀛楁瘝銆?濡傛灉瀹冨嚭鐜板湪琚祴璇曞肩殑浠讳綍鍦版柟锛屾寮忓氨鍖归厤(鍙浠栦滑鍖归厤鏁翠釜鍊硷紝SQL妯紡鍖归厤)銆?涓轰簡瀹氫綅涓涓寮忎互渚垮畠蹇呴鍖归厤琚祴璇曞肩殑寮濮嬫垨缁撳熬锛屽湪妯紡寮濮嬪浣跨敤鈥淾鈥濇垨鍦寮忕殑 缁撳熬鐢?鈥濄?涓轰簡璇存槑鎵睍姝垯琛揪寮忓浣曞伐浣滐紝涓婇潰鎵绀虹殑LIKE鏌鍦笅闈娇鐢EGEXP閲嶅啓锛?涓轰簡鎵惧嚭浠渂鈥濆紑澶寸殑鍚嶅瓧锛屼娇鐢淾鈥濆尮閰嶅悕瀛楃殑寮濮嬪苟涓斺淸bB鈥濆尮閰嶅皬鍐欐垨
8、澶啓鐨勨渂鈥濓細 mysql SELECT * FROM pet WHERE name REGEXP bB; +-+-+-+-+-+-+ | name | owner | species | sex | birth | death | +-+-+-+-+-+-+ | Buffy | Harold | dog | f | 1989-05-13 | NULL | | Bowser | Diane | dog | m | 1989-08-31 | 1995-07-29 | +-+-+-+-+-+-+ 涓轰簡鎵惧嚭浠渇y鈥濈粨灏剧殑鍚嶅瓧锛屼娇鐢?鈥濆尮閰嶅悕瀛楃殑缁撳熬锛?mysql SELECT
9、* FROM pet WHERE name REGEXP fy$; +-+-+-+-+-+-+ | name | owner | species | sex | birth | death | +-+-+-+-+-+-+ | Fluffy | Harold | cat | f | 1993-02-04 | NULL | | Buffy | Harold | dog | f | 1989-05-13 | NULL | +-+-+-+-+-+-+ 涓轰簡鎵惧嚭鍖呭惈涓涓渨鈥濈殑鍚嶅瓧锛屼娇鐢淸wW鈥濆尮閰嶅皬鍐欐垨澶啓鐨勨渨鈥濓細 mysql SELECT * FROM pet WHERE nam
10、e REGEXP wW; +-+-+-+-+-+-+ | name | owner | species | sex | birth | death | +-+-+-+-+-+-+ | Claws | Gwen | cat | m | 1994-03-17 | NULL | | Bowser | Diane | dog | m | 1989-08-31 | 1995-07-29 | | Whistler | Gwen | bird | NULL | 1997-12-09 | NULL | +-+-+-+-+-+-+ 鏃劧濡傛灉涓涓瑙勮杈惧紡鍑虹幇鍦肩殑浠讳綍鍦版柟锛屽叾妯紡鍖归厤浜嗭紝灏变笉蹇呭
11、啀鍏堝墠鐨勬煡璇腑鍦寮忕殑涓?鏂归潰鏀剧疆涓涓氶厤绗互浣垮緱瀹冨尮閰嶆暣涓硷紝灏卞儚濡傛灉浣犱娇鐢簡涓涓猄QL妯紡閭牱銆?涓轰簡鎵惧嚭鍖呭惈姝5涓瓧绗殑鍚嶅瓧锛屼娇鐢淾鈥濆拰鈥?鈥濆尮閰嶅悕瀛楃殑寮濮嬪拰缁撳熬锛屽拰5涓?鈥濆疄渚嬪湪 涓呬箣闂达細 mysql SELECT * FROM pet WHERE name REGEXP .$; +-+-+-+-+-+-+ | name | owner | species | sex | birth | death | +-+-+-+-+-+-+ | Claws | Gwen | cat | m | 1994-03-17 | NULL | | Buffy | Harold | dog | f | 1989-05-13 | NULL | +-+-+-+-+-+-+ 浣犱篃鍙互浣跨敤鈥渰n鈥濃滈噸澶峮娆濇搷浣滅閲嶅啓鍏堝墠鐨勬煡璇細 mysq
