wordpress批量修改post_name值
wordpress的postname是文章的别名,可以用作索引及url固定连接。可以通过SQL命令进行wordpress批量修改post_name值。
1、修改ID(1000)的post_name为newname
UPDATE `wp_posts` SET `post_name` = 'newname' WHERE `ms_posts`.`ID` = 1000;
2、设置ID(1-1000)的post_name为ID
update wp_posts set post_name= concat('',ID)
where post_status = 'publish'
and post_type = 'post'
and `ID` between 1 AND 1000;
注:此命令只能重置原post_name为空值
精选留言