今天有个朋友的DT系统生成静态出现
MySQL Query:SELECT * FROM [pre]article_21 WHERE status=3 and itemid<>516548 and keyword like '%龙慧祺 ORDER BY addtime desc LIMIT 0,10 MySQL Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''%龙慧祺 ORDER BY addtime desc LIMIT 0,10' at line 1 MySQL Errno:0 Message:MySQL Query Error
所以具体解决办法:
用mysql工具进行查询:
update destoon_article_21 set fromurl = replace(fromurl,"[db:来源链接]","http://zhimo.yuanzhumuban.cc/");
update destoon_article_21 set title = replace(title,""","");
update destoon_article_21 set introduce = replace(introduce,""","");
update destoon_article_21 set keyword= replace(keyword,""","");
update destoon_article_21 set tag = replace(tag,""","");
这样就能解决了,如果有其他好方法,可以一起共享!