mysql> select * from en;
+------+---------------------+
| id | name |
+------+---------------------+
| 1 | jhttp://www.hn87.com |
| 2 | Bhttp://www.csdsssssn.com |
| 3 | Chttp://www.csdn.com |
| 4 | 2010-01-07 19:42:55 |
+------+---------------------+
4 rows in set (0.00 sec)我要如何删除http://www.*.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)
+------+---------------------+
| id | name |
+------+---------------------+
| 1 | jhttp://www.hn87.com |
| 2 | Bhttp://www.csdsssssn.com |
| 3 | Chttp://www.csdn.com |
| 4 | 2010-01-07 19:42:55 |
+------+---------------------+
4 rows in set (0.00 sec)我要如何删除http://www.*.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)
set name=replace(name,'http://www.*.com','');
SET NAME=LEFT(NAME,1)
WHERE FIND_IN_SET('http://www',NAME)>0
+------+------------------------+
| id | name |
+------+------------------------+
| 1 | A |
| 2 | B |
| 3 | C |
| 4 | 2010-01-07 19:42:55 |
| 5 | sadfsadf |
| 5 | sadfsadf |
| 6 | http://www.sina.com |
| 6 | http://www.hn87a.com |
| 6 | http://www.hn8700a.com |
+------+------------------------+
9 rows in set (0.00 sec)mysql> update en set name=replace(name,"http://www.*.com",'');
Query OK, 0 rows affected (0.00 sec)
Rows matched: 9 Changed: 0 Warnings: 0mysql> select * from en;
+------+------------------------+
| id | name |
+------+------------------------+
| 1 | A |
| 2 | B |
| 3 | C |
| 4 | 2010-01-07 19:42:55 |
| 5 | sadfsadf |
| 5 | sadfsadf |
| 6 | http://www.sina.com |
| 6 | http://www.hn87a.com |
| 6 | http://www.hn8700a.com |
+------+------------------------+
9 rows in set (0.00 sec)mysql>还是不行啊...
set name=concat(left(name,instr(name,'http://www.')-1),mid(name,instr(name,'.com')+4))
where name like 'http://www.%.com'
set name=concat(left(name,instr(name,'http://www.')-1),mid(name,instr(name,'.com')+4))
where name like 'http://www.%.com'是什么意思吗?