MySQL字符串查找替换更新_记录

	use wordpressDB;

	select post_title from wp_posts limit 1000;

	select * from wp_posts where post_title="《树莓派LED呼吸灯》" ;

	SELECT post_title FROM wp_posts WHERE post_title LIKE "《%"; 

	select replace(replace(post_title, "《", ""),"》", "") 

	from wp_posts where post_title="《树莓派LED呼吸灯》" ;

	SET SQL_SAFE_UPDATES=0;  //取消强制安全点限制

	update wp_posts set post_title = replace(replace(post_title, "《", ""),"》", "")  where  post_title="《树莓派LED呼吸灯》" 

	update wp_posts set post_title = replace(replace(post_title, "《", ""),"》", "")  //所有

	SET SQL_SAFE_UPDATES=1; //启用强制安全点限制

推荐阅读

热点文章