Mysql函数->TRIM(去掉首尾空格、任意字符)

<div class="blogpost-body blogpost-body-html" style="font-size: medium; white-space: normal; margin-bottom: 20px; word-break: break-word; font-family: &quot;PingFang SC&quot;, &quot;Microsoft YaHei&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif;"><p style="margin: 10px auto;"><strong><span style="font-size: 18pt;">TRIM</span></strong></p><p style="margin: 10px auto;"><span style="font-size: 18px;">语法</span></p><p style="margin: 10px auto;"><span style="font-size: 18px; color: rgb(208, 48, 55); background-color: rgb(249, 244, 242);">TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str)</span></p><table><tbody><tr class="firstRow"><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">序号</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">函数&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">函数结果&nbsp; &nbsp; &nbsp;&nbsp;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">备注</span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">1</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">trim(&#39; test &#39;)</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39;test&#39;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">删除字符串前后空格</span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">2</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">trim(both from &#39; test &#39;)</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39;test&#39;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39;both&#39;参数表示同时去除字符串前后所指定的内容（默认情况下删除空格）</span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">3</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">trim(trailing from &#39; test &#39;)</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39; test&#39;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39;trailing&#39;参数表示删除字符串尾部空格</span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">4</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">trim(leading from &#39; test &#39;)</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39;test &#39;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39;leading&#39;参数表示删除字符串头部空格</span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">5</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">trim(&#39;x&#39; from &#39;xxxtestxxx&#39;)</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39;test&#39;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">删除字符串前后的字符&#39;x&#39;&nbsp;</span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">6</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">trim(both &#39;x&#39; from &#39;xxxtestxxx&#39;)</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39;test&#39;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">删除字符串前后的字符&#39;x&#39;</span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">7</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">trim(trailing &#39;xy&#39; from&nbsp; &#39;xyxyxtestxxyxy&#39;)</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39;xyxyxtestx&#39;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">删除字符串尾部的字符串&#39;xy&#39;</span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">8</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">trim(leading &#39;xy&#39; from &#39;xyxyxtestxxyxy&#39;)</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39;xtestxxyxy&#39;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">删除字符串头部的字符串&#39;xy&#39;</span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;">9</td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;">trim(leading &#39;xy&#39; from trim(trailing &#39;xy&#39; from&nbsp; &#39;xyxtestxxy&#39;))</td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;">&#39;xtestx&#39;</td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;">删除字符串头尾的字符&#39;xy&#39;</td></tr></tbody></table><p style="margin: 10px auto;"><strong><span style="font-size: 18pt;">LTRIM / RTRIM</span></strong>&nbsp;</p><p style="margin: 10px auto;"><span style="font-size: 18px;">去掉字符串左/右边的空格</span></p><table><tbody><tr class="firstRow"><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">序号</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">函数　　　　　　　　　　　　　　　　　　　　　　　　</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">函数结果　　　　</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">备注　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　<br/></span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">1</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">ltrim(&#39; test &#39;)</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39;test &#39;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">去掉字符串左边的空格</span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">2</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">rtrim(&#39; test &#39;)</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">&#39; test&#39;</span></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><span style="font-size: 14px;">去掉字符串右边的空格</span></td></tr><tr><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px; word-break: break-all;"><br/></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><br/></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><br/></td><td style="border-color: rgb(192, 192, 192); border-collapse: collapse; padding: 8px 14px; min-width: 50px;"><br/></td></tr></tbody></table></div><div style="font-size: medium; white-space: normal; font-family: &quot;PingFang SC&quot;, &quot;Microsoft YaHei&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif;"><div>作者：<a href="https://home.cnblogs.com/u/kiko2014551511/" target="_blank" style="text-decoration-line: none; font-family: -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, &quot;Noto Sans&quot;, &quot;Liberation Sans&quot;, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;; color: rgb(51, 122, 183);">小念</a></div><div>出处：<a href="https://www.cnblogs.com/kiko2014551511/" target="_blank" style="text-decoration-line: none; font-family: -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, &quot;Noto Sans&quot;, &quot;Liberation Sans&quot;, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;; color: rgb(51, 122, 183);">https://www.cnblogs.com/kiko2014551511/</a></div></div><p><br/></p>