{"id":293,"title":"sql\u5e38\u7528\u5b57\u7b26\u51fd\u6570","good":0,"bad":0,"hit":2608,"created_at":"2018-06-14 22:19:27","content":"<p>\u5b57\u7b26\u51fd\u6570<\/p><p>concat\uff08&#39;hu&#39;,&#39;rong&#39;) \u5b57\u7b26\u8fde\u63a5<\/p><p>concat_ws\uff08&#39;|&#39;,&#39;hu&#39;,&#39;rong&#39;\uff09 \u7528\u6307\u5b9a\u7684\u5206\u9694\u7b26\u8fdb\u884c\u5b57\u7b26\u4e32\u8fde\u63a5<\/p><p>format(12345.67,1) -&gt;\u5b57\u7b26\u4e32\u683c\u5f0f\u5316\uff1a123,45.7<\/p><p>lower\u8f6c\u6362\u6210\u5c0f\u5199<\/p><p>uppper\u8f6c\u6362\u6210\u5927\u5199<\/p><p>left\u53d6\u5de6\u4fa7\u5b57\u7b26\uff1aleft(&#39;mysql&#39;,2)-&gt;my<\/p><p>right\u53d6\u53f3\u4fa7\u5b57\u7b26<\/p><p>length\u53d6\u957f\u5ea6<\/p><p>ltrim:\u5220\u9664\u5de6\u7a7a\u683c<\/p><p>rtrim:\u5220\u9664\u53f3\u7a7a\u683c<\/p><p>trim\uff1a\u5220\u9664\u5de6\u53f3\u7a7a\u683c<\/p><p>substring:\u5b57\u7b26\u4e32\u622a\u53d6\uff0c\u4e0ephp\u4e0d\u540c\uff0c\u7b2c\u4e00\u4e2a\u4f4d\u7f6e\u6807\u8bc6\u662f1\uff0c\u4e0d\u662f0<\/p><p>replace:\u5b57\u7b26\u66ff\u6362&nbsp;<\/p><p>\u901a\u914d\u7b26\uff1a\u67e5\u627e\u540d\u5b57\u4e2d\u6709%\u53f7\u7684(\u4e0b\u9762\u8868\u793a1\u540e\u53f0\u7684%\u4e0d\u662f\u901a\u914d\u7b26\uff0c\u800c\u5c31\u662f\u4e00\u4e2a%)<\/p><p>select * from users where name like &#39;%1%%&#39; ESCAPE &#39;1&#39;;<\/p><p><br\/><\/p>"}