SQL\u6a21\u7cca\u67e5\u8be2\u8bed\u53e5<\/title><\/head><body><\/p>\n<h1 style=\"display:none\">SQL\u6a21\u7cca\u67e5\u8be2\u8bed\u53e5<\/h1>\n<div>\nSELECT * FROM user WHERE name LIKE ‘%\u4e09%’; \n\u5c06\u4f1a\u628aname\u4e3a“\u5f20\u4e09”\uff0c“\u4e09\u811a\u732b”\uff0c“\u5510\u4e09\u85cf”\u7b49\u7b49\u6709“\u4e09”\u7684\u5168\u627e\u51fa\u6765\uff1b<\/p>\n\u5728\u8fdb\u884c\u6570\u636e\u5e93\u67e5\u8be2\u65f6\uff0c\u6709\u5b8c\u6574\u67e5\u8be2\u548c\u6a21\u7cca\u67e5\u8be2\u4e4b\u5206\u3002<\/p>\n\u4e00\u822c\u6a21\u7cca\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\nSELECT \u5b57\u6bb5 FROM \u8868 WHERE \u67d0\u5b57\u6bb5 Like \u6761\u4ef6<\/p>\n\u5176\u4e2d\u5173\u4e8e\u6761\u4ef6\uff0cSQL\u63d0\u4f9b\u4e86\u56db\u79cd\u5339\u914d\u6a21\u5f0f\uff1a<\/p>\n1\uff0c%\uff1a\u8868\u793a\u4efb\u610f0\u4e2a\u6216\u591a\u4e2a\u5b57\u7b26\u3002\u53ef\u5339\u914d\u4efb\u610f\u7c7b\u578b\u548c\u957f\u5ea6\u7684\u5b57\u7b26\uff0c\u6709\u4e9b\u60c5\u51b5\u4e0b\u82e5\u662f\u4e2d\u6587\uff0c\u8bf7\u4f7f\u7528\u4e24\u4e2a\u767e\u5206\u53f7\uff08%%\uff09\u8868\u793a\u3002<\/p>\n\u6bd4\u5982 SELECT * FROM [user] WHERE u_name LIKE ‘%\u4e09%’<\/p>\n\u5c06\u4f1a\u628au_name\u4e3a“\u5f20\u4e09”\uff0c“\u5f20\u732b\u4e09”\u3001“\u4e09\u811a\u732b”\uff0c“\u5510\u4e09\u85cf”\u7b49\u7b49\u6709“\u4e09”\u7684\u8bb0\u5f55\u5168\u627e\u51fa\u6765\u3002<\/p>\n\u53e6\u5916\uff0c\u5982\u679c\u9700\u8981\u627e\u51fau_name\u4e2d\u65e2\u6709“\u4e09”\u53c8\u6709“\u732b”\u7684\u8bb0\u5f55\uff0c\u8bf7\u4f7f\u7528and\u6761\u4ef6 \nSELECT * FROM [user] WHERE u_name LIKE ‘%\u4e09%’ AND u_name LIKE ‘%\u732b%’<\/p>\n\u82e5\u4f7f\u7528 SELECT * FROM [user] WHERE u_name LIKE ‘%\u4e09%\u732b%’ \n\u867d\u7136\u80fd\u641c\u7d22\u51fa“\u4e09\u811a\u732b”\uff0c\u4f46\u4e0d\u80fd\u641c\u7d22\u51fa\u7b26\u5408\u6761\u4ef6\u7684“\u5f20\u732b\u4e09”\u3002<\/p>\n2\uff0c_\uff1a \u8868\u793a\u4efb\u610f\u5355\u4e2a\u5b57\u7b26\u3002\u5339\u914d\u5355\u4e2a\u4efb\u610f\u5b57\u7b26\uff0c\u5b83\u5e38\u7528\u6765\u9650\u5236\u8868\u8fbe\u5f0f\u7684\u5b57\u7b26\u957f\u5ea6\u8bed\u53e5\uff1a<\/p>\n\u6bd4\u5982 SELECT * FROM [user] WHERE u_name LIKE ‘_\u4e09_’ \n\u53ea\u627e\u51fa“\u5510\u4e09\u85cf”\u8fd9\u6837u_name\u4e3a\u4e09\u4e2a\u5b57\u4e14\u4e2d\u95f4\u4e00\u4e2a\u5b57\u662f“\u4e09”\u7684\uff1b<\/p>\n\u518d\u6bd4\u5982 SELECT * FROM [user] WHERE u_name LIKE ‘\u4e09__’; \n\u53ea\u627e\u51fa“\u4e09\u811a\u732b”\u8fd9\u6837name\u4e3a\u4e09\u4e2a\u5b57\u4e14\u7b2c\u4e00\u4e2a\u5b57\u662f“\u4e09”\u7684\uff1b<\/p>\n3\uff0c[ ]\uff1a\u8868\u793a\u62ec\u53f7\u5185\u6240\u5217\u5b57\u7b26\u4e2d\u7684\u4e00\u4e2a\uff08\u7c7b\u4f3c\u6b63\u5219\u8868\u8fbe\u5f0f\uff09\u3002\u6307\u5b9a\u4e00\u4e2a\u5b57\u7b26\u3001\u5b57\u7b26\u4e32\u6216\u8303\u56f4\uff0c\u8981\u6c42\u6240\u5339\u914d\u5bf9\u8c61\u4e3a\u5b83\u4eec\u4e2d\u7684\u4efb\u4e00\u4e2a\u3002<\/p>\n\u6bd4\u5982 SELECT * FROM [user] WHERE u_name LIKE ‘[\u5f20\u674e\u738b]\u4e09’ \n\u5c06\u627e\u51fa“\u5f20\u4e09”\u3001“\u674e\u4e09”\u3001“\u738b\u4e09”\uff08\u800c\u4e0d\u662f“\u5f20\u674e\u738b\u4e09”\uff09\uff1b<\/p>\n\u5982 [ ] \u5185\u6709\u4e00\u7cfb\u5217\u5b57\u7b26\uff0801234\u3001abcde\u4e4b\u7c7b\u7684\uff09\u5219\u53ef\u7565\u5199\u4e3a“0-4”\u3001“a-e” \nSELECT * FROM [user] WHERE u_name LIKE ‘\u8001[1-9]’ \n\u5c06\u627e\u51fa“\u80011”\u3001“\u80012”\u3001\u2026\u2026\u3001“\u80019”\uff1b<\/p>\n4\uff0c[^ ] \uff1a\u8868\u793a\u4e0d\u5728\u62ec\u53f7\u6240\u5217\u4e4b\u5185\u7684\u5355\u4e2a\u5b57\u7b26\u3002\u5176\u53d6\u503c\u548c [] \u76f8\u540c\uff0c\u4f46\u5b83\u8981\u6c42\u6240\u5339\u914d\u5bf9\u8c61\u4e3a\u6307\u5b9a\u5b57\u7b26\u4ee5\u5916\u7684\u4efb\u4e00\u4e2a\u5b57\u7b26\u3002<\/p>\n\u6bd4\u5982 SELECT * FROM [user] WHERE u_name LIKE ‘[^\u5f20\u674e\u738b]\u4e09’ \n\u5c06\u627e\u51fa\u4e0d\u59d3“\u5f20”\u3001“\u674e”\u3001“\u738b”\u7684“\u8d75\u4e09”\u3001“\u5b59\u4e09”\u7b49\uff1b<\/p>\nSELECT * FROM [user] WHERE u_name LIKE ‘\u8001[^1-4]’; \n\u5c06\u6392\u9664“\u80011”\u5230“\u80014”\uff0c\u5bfb\u627e“\u80015”\u3001“\u80016”\u3001\u2026\u2026<\/p>\n5\uff0c\u67e5\u8be2\u5185\u5bb9\u5305\u542b\u901a\u914d\u7b26\u65f6<\/p>\n\u7531\u4e8e\u901a\u914d\u7b26\u7684\u7f18\u6545\uff0c\u5bfc\u81f4\u6211\u4eec\u67e5\u8be2\u7279\u6b8a\u5b57\u7b26“%”\u3001“_”\u3001“[”\u7684\u8bed\u53e5\u65e0\u6cd5\u6b63\u5e38\u5b9e\u73b0\uff0c\u800c\u628a\u7279\u6b8a\u5b57\u7b26\u7528“[ ]”\u62ec\u8d77\u4fbf\u53ef\u6b63\u5e38\u67e5\u8be2\u3002\u636e\u6b64\u6211\u4eec\u5199\u51fa\u4ee5\u4e0b\u51fd\u6570\uff1a<\/p>\nfunction sqlencode(str) \nstr=replace(str,"[","[[]") ‘\u6b64\u53e5\u4e00\u5b9a\u8981\u5728\u6700\u524d \nstr=replace(str,"_","[_]") \nstr=replace(str,"%","[%]") \nsqlencode=str \nend function<\/p>\naccess<\/p>\n\u5728\u8fd1\u65e5\u7684\u5199Web\u7a0b\u5e8f\u65f6\u7528\u5230\u4e86Access\u7684\u6a21\u7cca\u67e5\u8be2,\u5728Acces\u91cc\u5199\u4ee3\u7801\u600e\u4e48\u4e5f\u627e\u4e0d\u5230\u8bb0\u5f55,\u540e\u6765\u624d\u8d77\u6765\u539f\u6765Acess\u548cSqlServer\u7684\u6a21\u7cca\u67e5\u8be2\u662f\u6709\u7279\u522b\u7684 \n\u6761\u4ef6:\u67e5\u627e\u8868A \u7684Name\u5b57\u6bb5\u4e2d\u5305\u62ec "B" \u7684\u8bb0\u5f53 \n\u5728Access\u91cc\u7684\u4ee3\u7801:<\/p>\n1 Select * from a where name like ‘*b*’Sql Server\u67e5\u8be2\u5206\u6790\u5668\u7684\u4ee3\u7801 \nSelect * from a where name like ‘%b%’\u8fd9\u65f6\u4f60\u4f1a\u53d1\u73b0Access\u91cc\u53ef\u4ee5\u627e\u5230\u76f8\u5173\u7684\u8bb0\u5f55,\u4f46\u628a’*’\u5fc5\u6210’%’\u5c31\u627e\u4e0d\u5230\u4e86,\u539f\u56e0\u662fAccess\u7684\u6a21\u7cca\u67e5\u8be2\u662f’?’,’*’ \n\u548cSql server\u4e0d\u4e00\u6837 \n\u4ee5\u4e0a\u53ea\u662f\u5728\u6570\u636e\u5e93\u4e2d\u7684\u4ee3\u7801,\u5982\u679c\u8981\u5199\u5728\u7a0b\u5e8f\u91cc\u53ef\u5c31\u4e0d\u80fd\u7528.’*’\u4e86,\u8fd8\u662f\u8981\u7528’%’ \n\u7a0b\u5e8f: \nstrSql="select * from a where name like ‘%b%’"\u6240\u4ee5\u5982\u679c\u6709\u670b\u53cb\u548c\u6211\u4e00\u6837\u559c\u6b22\u5148\u5728\u6570\u636e\u5e93\u4e2d\u4ee3\u7801\u6d4b\u8bd5,\u90a3\u53ef\u5c31\u8981\u6ce8\u610f\u4e86!!<\/p>\n<\/div>\n<\/body><\/html><\/p>\n","protected":false},"excerpt":{"rendered":"SQL\u6a21\u7cca\u67e5\u8be2\u8bed\u53e5 SQL\u6a21\u7cca\u67e5\u8be2\u8bed\u53e5 SELECT * FROM user WHERE name LIKE […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-1042","post","type-post","status-publish","format-standard","hentry","category-code_related"],"_links":{"self":[{"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/posts\/1042","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/comments?post=1042"}],"version-history":[{"count":0,"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/posts\/1042\/revisions"}],"wp:attachment":[{"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/media?parent=1042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/categories?post=1042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/tags?post=1042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

{"id":1042,"date":"2010-04-25T18:16:00","date_gmt":"2010-04-25T10:16:00","guid":{"rendered":""},"modified":"2010-04-25T18:16:00","modified_gmt":"2010-04-25T10:16:00","slug":"","status":"publish","type":"post","link":"https:\/\/kyle.ai\/blog\/1042.html","title":{"rendered":"SQL\u6a21\u7cca\u67e5\u8be2\u8bed\u53e5"},"content":{"rendered":"