SELECT * FROM 24htime.wp_posts;
SELECT * FROM 24htime.wp_posts where `post_content` like '%121.40.225.215%';
UPDATE `24htime`.`wp_posts` SET `post_content` = replace(`post_content`,'121.401.225.215','www.24htime.com')
WHERE `post_content` like '%121.401.225.215%';
SET SQL_SAFE_UPDATES = 0;
safe-updates模式下,该模式会导致非主键条件下无法执行update或者delete命令,执行命令SET SQL_SAFE_UPDATES = 0;修改下数据库模式
sql 替换语句
最新推荐文章于 2023-08-21 13:23:26 发布