问题求解~
以下是数据库一个表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),'');
出错了! 麻烦帮我解答该怎么样写? 先谢谢了!