1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

如何替换mysql指定表内的html代码

Discussion in '后端开发' started by shaun, Apr 16, 2006.

  1. shaun

    shaun New Member

    Joined:
    Mar 22, 2006
    Messages:
    75
    Likes Received:
    0
    例如把所有<br>全部替换掉

    怎么写呢

    已知

    update content set title =replace(title, '<br>','');

    但试了不行
     
  2. 小叶

    小叶 New Member

    Joined:
    Sep 4, 2005
    Messages:
    17,941
    Likes Received:
    33
    update content set title =replace(title, '&lt;br&gt;','');

    试试这个,可能你在写入的时候,使用了。htmlspecialchars