以下是数据库一个表afk +----+------------------------------------------+
| id | content |
+----+------------------------------------------+
| 1 | sdfsf<a href="http://www.ffff.co">ffff</a>sldjfsld |
| 2 | sdfsf<a href="http://www.aaaa.co">adgaty</a>sldjfsld |
| 3 | sdfsf<a href="http://www.bbbb.co">ewgg</a>sldjfsld |
| 4 | sdfsf<a href="http://www.cccc.co">awyth</a>sldjfsld |
+----+------------------------------------------+
想的到结果:+----+-------------------+
| id | content |
+----+-------------------+
| 1 | sdfsfactsldjfsld |
| 2 | sdfsfactsldjfsld |
| 3 | sdfsfactsldjfsld |
| 4 | sdfsfactsldjfsld |
+----+-------------------+ 执行语句:
UPDATE `afk` SET content = REPLACE(content,CONCAT('<a href="',SUBSTRING_INDEX(SUBSTRING_INDEX(content,'<a href="',-1),'a>',1),'');
出错了! 麻烦帮我解答该怎么样写? 先谢谢了!substring数据库
| id | content |
+----+------------------------------------------+
| 1 | sdfsf<a href="http://www.ffff.co">ffff</a>sldjfsld |
| 2 | sdfsf<a href="http://www.aaaa.co">adgaty</a>sldjfsld |
| 3 | sdfsf<a href="http://www.bbbb.co">ewgg</a>sldjfsld |
| 4 | sdfsf<a href="http://www.cccc.co">awyth</a>sldjfsld |
+----+------------------------------------------+
想的到结果:+----+-------------------+
| id | content |
+----+-------------------+
| 1 | sdfsfactsldjfsld |
| 2 | sdfsfactsldjfsld |
| 3 | sdfsfactsldjfsld |
| 4 | sdfsfactsldjfsld |
+----+-------------------+ 执行语句:
UPDATE `afk` SET content = REPLACE(content,CONCAT('<a href="',SUBSTRING_INDEX(SUBSTRING_INDEX(content,'<a href="',-1),'a>',1),'');
出错了! 麻烦帮我解答该怎么样写? 先谢谢了!substring数据库
REPLACE(content,
MID(content,INSTR(content,'<a'),INSTR(content,'/a>')-INSTR(content,'<a')+3),'')