DT资讯文章生成静态出现MySQL Error解决办法

     今天有个朋友的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://www.kaotop.com/");
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,""","");

  这样就能解决了,如果有其他好方法,可以一起共享!

posted @ 2018-03-13 09:33  圆柱模板  阅读(265)  评论(0编辑  收藏  举报