求助啊，求助啊，update不能更新mediumtext 类型啊

这个字段里面有很多无用的P标签，想删除

<p>&nbsp;</p> 想给删除掉，但SQL不起作用，不知道为什么，求帮助

字段名 content
类型 mediumtext 

SQL code

update phpcms_c_news set `content`=replace(`content`,'<p>&nbsp;</p>',concat(''))

应该可以， 字段内容是什么
update phpcms_c_news set `content`=replace(`content`,'<p>&nbsp;</p>','')

你的语句并无问题啊？ 你所谓的错误是什么？

SQL code

mysql> select * from phpcms_c_news;
+---------------+
| content       |
+---------------+
| <p>&nbsp;</p> |
+---------------+
1 row in set (0.07 sec)

mysql> desc phpcms_c_news;
+---------+------------+------+-----+---------+-------+
| Field   | Type       | Null | Key | Default | Extra |
+---------+------------+------+-----+---------+-------+
| content | mediumtext | YES  |     | NULL    |       |
+---------+------------+------+-----+---------+-------+
1 row in set (0.10 sec)

mysql> update phpcms_c_news set `content`=replace(`content`,'<p>&nbsp;</p>',conc
at(''));
Query OK, 1 row affected (0.08 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from phpcms_c_news;
+---------+
| content |
+---------+
|         |
+---------+
1 row in set (0.00 sec)

mysql>