今天因为要把另一个blog上文章的地址改一下，所以就找到以下语句
替换“blog内容”中含有 “www.ijanezhang.cn”的字符为“www.ijanezhang.com”
update wp_posts set blog内容=REPLACE(blog内容,’www.ijanezhang.cn‘,’www.ijanezhang.com‘) where blog内容 like ‘%www.ijanezhang.cn%’
September 6, 2007
sql替换语句
关注回复 | 地址
Welcome to the world of blogging, it’s truly revolutionized the industry of the Internet, in my opinion. I spend more time writing in blogs than I do actually reading them, but overall you’ll find them useful I think.
Thanks for making the world a more open space.