mysql oracle trim_MySQL trim()函数

TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str)

TRIM([remstr FROM] str)

返回字符串str，删除所有 remstr 前缀或后缀。如果没有符 BOTH, LEADING, 或TRAILING给出，假定则是BOTH(默认的)。remstr为可任选的，如果未指定，空格被删除。

mysql> SELECT TRIM(' bar ');

+---------------------------------------------------------+

| TRIM(' bar ') |

+---------------------------------------------------------+

| bar |

+---------------------------------------------------------+

1 row in set (0.00 sec)

mysql> SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx');

+---------------------------------------------------------+

| TRIM(LEADING 'x' FROM 'xxxbarxxx') |

+---------------------------------------------------------+

| barxxx |

+---------------------------------------------------------+

1 row in set (0.00 sec)

mysql> SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx');

+---------------------------------------------------------+

| TRIM(BOTH 'x' FROM 'xxxbarxxx') |

+---------------------------------------------------------+

| bar |

+---------------------------------------------------------+

1 row in set (0.00 sec)

mysql> SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz');

+---------------------------------------------------------+

| TRIM(TRAILING 'xyz' FROM 'barxxyz') |

+---------------------------------------------------------+

| barx |

+---------------------------------------------------------+

1 row in set (0.00 sec)

¥ 我要打赏

纠错/补充

收藏

加QQ群啦，易百教程官方技术学习群

注意：建议每个人选自己的技术方向加群，同一个QQ最多限加 3 个群。