{"id":1773,"date":"2010-07-27T20:24:21","date_gmt":"2010-07-27T12:24:21","guid":{"rendered":"\/?p=1773"},"modified":"2010-07-27T20:24:21","modified_gmt":"2010-07-27T12:24:21","slug":"1773","status":"publish","type":"post","link":"https:\/\/www.justzz.com\/spec\/1773.html","title":{"rendered":"SQL\u4e2d\u66ff\u4ee3Like\u8bed\u53e5\u7684\u65b9\u6cd5"},"content":{"rendered":"<div>\n<p><font face=\"\u5b8b\u4f53\">1\u3001like '%string%' \u548c like '%string' \u4e0d\u4f1a\u4f7f\u7528\u5217\u4e0a\u7684\u7d22\u5f15\uff0c\u4e14\u6548\u7387\u4f4e\uff0c\u672c\u6587\u66ff\u4ee3like\u4e3b\u8981\u5bf9\u6b64\u60c5\u51b5\u8fdb\u884c<br \/>2\u3001like 'string%' \u548c like 'sting%string' \u80fd\u591f\u4f7f\u7528\u5217\u4e0a\u7684\u7d22\u5f15<\/font><\/p>\n<p>&nbsp;<\/p>\n<p><font face=\"\u5b8b\u4f53\"><strong>SqlServer\u6570\u636e\u5e93\uff1a<\/strong><\/font><\/p>\n<p>&nbsp;<\/p>\n<p><font face=\"\u5b8b\u4f53\">\u4f7f\u7528CHARINDEX\u51fd\u6570<\/font><\/p>\n<p>&nbsp;<\/p>\n<p><font face=\"\u5b8b\u4f53\">\u4f8b\uff1a<\/font><\/p>\n<p><font face=\"\u5b8b\u4f53\">\u66ff\u4ee3\u524d\uff1a<br \/>\u3000\u3000<\/font><font color=\"#990099\">select tId, tName from tb_Test where tName like'%abc%\"<\/font><br \/>\u66ff\u4ee3\u540e\uff1a<br \/>\u3000\u3000<font color=\"#990099\">select tId, tName from tb_Test where charindex('abc',tName)&gt;0<\/font><\/p>\n<p>&nbsp;<\/p>\n<p><font face=\"\u5b8b\u4f53\"><strong>Oracle\u6570\u636e\u5e93\uff1a<\/strong><\/font><\/p>\n<p><strong><\/strong>&nbsp;<\/p>\n<p><font face=\"\u5b8b\u4f53\">\u4f7f\u7528INSTR\u51fd\u6570<\/font><\/p>\n<p>&nbsp;<\/p>\n<p><font face=\"\u5b8b\u4f53\">\u4f8b\uff1a<\/font><\/p>\n<p><font face=\"\u5b8b\u4f53\">\u66ff\u4ee3\u524d\uff1a<br \/>\u3000\u3000<\/font><font color=\"#990099\">select tId, tName from tb_Test where tName like'%abc%\"<\/font><br \/>\u66ff\u4ee3\u540e\uff1a<br \/>\u3000\u3000<font color=\"#990099\">select tId, tName from tb_Test where instr(tName\uff0c'abc')&gt;0<\/font><\/p>\n<p><font face=\"\u5b8b\u4f53\">\u53e6\uff1a\u5bf9like '%..'\u578b\uff0cOracle\u6570\u636e\u5e93\u53ef\u91c7\u7528\u4e0b\u8ff0\u66ff\u4ee3\u65b9\u6848\uff1a<br \/>&nbsp;&nbsp;&nbsp; <\/font><font color=\"#990099\">select tId, tName from tb_Test where reverse(tName) like reverse('%abc')<\/font><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001like '%string%' \u548c like '%string' \u4e0d\u4f1a\u4f7f\u7528\u5217\u4e0a\u7684\u7d22\u5f15\uff0c\u4e14\u6548\u7387\u4f4e\uff0c\u672c\u6587\u66ff\u4ee3like\u4e3b\u8981\u5bf9\u6b64\u60c5\u51b5\u8fdb\u884c2\u3001like 'string%' \u548c like 'sting%string' \u80fd\u591f\u4f7f\u7528\u5217\u4e0a\u7684\u7d22\u5f15 &nbsp; Sql&hellip;<\/p>\n","protected":false},"author":13,"featured_media":7704,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1773","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-t"],"_links":{"self":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/posts\/1773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/comments?post=1773"}],"version-history":[{"count":0,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/posts\/1773\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/media\/7704"}],"wp:attachment":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/media?parent=1773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/categories?post=1773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/tags?post=1773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}