mysql数据库中表数据带回车，怎么去掉，急等解决！

我们知道如果表中数据带有空格，可以用trim()函数去掉，但是如果数据带有回车，该怎么去掉？

---

replace

---

replace(xxxx,'\n','')

---

SQL code:

mysql> insert into test values('aaa\nbbb'),('ccc\naaa'),('e\n\nb');
Query OK, 3 rows affected (0.02 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select * from test;
+---------+
| str |
+---------+
| aaa
bbb |
| ccc
aaa |
| e

b |
+---------+
3 rows in set (0.02 sec)

mysql> update test set str=replace(str,'\n','');
Query OK, 3 rows affected (0.05 sec)
Rows matched: 3 Changed: 3 Warnings: 0

mysql> select * from test;
+--------+
| str |
+--------+
| aaabbb |
| cccaaa |
| eb |
+--------+
3 rows in set (0.00 sec)

---

非常感谢，按照楼上方法问题已解决！

---

当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html

---

正解。

引用

replace(xxxx,'\n','')