时间线

My Life My Style

替换数据表里指定内容

UPDATE `表名` SET `字段名`=REPLACE(`字段名`, ‘要替换内容’, ‘替换内容’);
====================
由于导入WordPress的数据带有很多写在文章和评论上的链接,直接跑phpmyadmin里边update了一把~
SQL语句见顶部…供需要的同学参考…

发表评论

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Connecting to %s

加关注

Get every new post delivered to your Inbox.