如果删除数据库指定内容？

Question

mysql> select * from en;
+------+---------------------+
| id   | name                |
+------+---------------------+
|    1 | jhttp://www.hn87.com                   |
|    2 | B                   |
|    3 | Chttp://www.hn87.com                   |
|    4 | 2010-01-07 19:42:55 |
+------+---------------------+
4 rows in set (0.00 sec)
我要如何删除http://www.hn87.com？让他显示成。mysql> select * from en;
+------+---------------------+
| id   | name                |
+------+---------------------+
|    1 | j                   |
|    2 | B                   |
|    3 | C                   |
|    4 | 2010-01-07 19:42:55 |
+------+---------------------+
4 rows in set (0.00 sec)

Answer 1

update en 
set name=replace(name,'http://www.hn87.com','')