mysql 去除字符串中的空格

最新推荐文章于 2022-09-02 11:47:20 发布

weixin_30745553

最新推荐文章于 2022-09-02 11:47:20 发布

阅读量889

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/sea-stream/p/11306589.html

版权

mysql> select "  ddd dddee ";
+--------------+
| ddd dddee    |
+--------------+
|   ddd dddee  |
+--------------+
1 row in set (0.00 sec)


mysql> select rtrim("  ddd dddee ");
+-----------------------+
| rtrim("  ddd dddee ") |
+-----------------------+
|   ddd dddee           |
+-----------------------+
1 row in set (0.00 sec)


mysql> select ltrim("  ddd dddee ");
+-----------------------+
| ltrim("  ddd dddee ") |
+-----------------------+
| ddd dddee             |
+-----------------------+
1 row in set (0.00 sec)


mysql> select trim("  ddd dddee ");
+----------------------+
| trim("  ddd dddee ") |
+----------------------+
| ddd dddee            |
+----------------------+
1 row in set (0.00 sec)