您好,麻烦问下请问如果在数据库里批量替换文章文本(比如:每个帖子里都有 xiuno 想替换成 noxiu)麻烦各位了
问一下AI就能轻松解决
UPDATE bbs_post SET message_fmt = REPLACE(message_fmt, 'xiuno', 'noxiu') WHERE message_fmt LIKE '%xiuno%';
UPDATE bbs_post SET message = REPLACE(message, 'xiuno', 'noxiu') WHERE message LIKE '%xiuno%';
Tillreetree 问一下AI就能轻松解决 UPDATE bbs_post SET message_fmt = REPLACE(message_fmt, 'xiuno', 'noxiu') WHERE message_ ...