首页 > 代码

批量删除wordpress内容,按标题内容字段字段长短

批量删除文章,按标题内容字段字段长短,

DELETE FROM wp_posts where length(post_title)<=2
DELETE FROM wp_posts where length(post_content)<=300
DELETE FROM wp_posts where length(post_content)>7500
DELETE FROM wp_terms where name like '%区别%';
DELETE FROM wp_terms where name like '%问题%';
DELETE FROM wp_terms where name like '%哪个%';
DELETE FROM wp_postmeta WHERE meta_value like '%/dj/%';
DELETE FROM wp_postmeta WHERE meta_value like '%/yj/%';
DELETE FROM wp_terms where length(name)>4
DELETE FROM wp_postmeta where post_id >= 100 and post_id <= 500;
DELETE FROM wp_wshop_pay_per_view where post_ID >= 100 and post_ID <= 500;
DELETE FROM wp_postmeta WHERE meta_key = '_edit_last';
update `wp_posts` set `post_status` = 'publish' WHERE `ID` between 1 AND 900


  • 彻底删除wordpress里的global-styles-inline-css
  • <style id='global-styles-inline-css' type= […]

  • 服务器上mysql数据库很多,某个库把整台服务器拉爆了,如何定位找到罪魁?
  • 服务器上mysql数据库很多,某个数据库把整台服务器拉爆了,如何定位找到罪魁? 先在 MySQL 里把“正在烧 […]

  • 批量设置wordpress文章分类,把文章 ID 区间为 1256869 到 1257421批量设置分类为 ID =5
  • 将 cuwen.wp_posts 中 文章 ID 区间为 1256869 到 1257421(含) 的文章批量 […]

  • 同一台服务器里的两个wordpress数据库文章内容叠加复制
  • 问题:同一台服务器里的两个wordpress数据库,我要把名为temp数据库里的wp_posts的所有文章 全 […]

  • WordPress 如何在首页与内页用不同的菜单或header
  • 开发wordpress主题时,首页的header内容与内页的header内容希望不一样,这时就要用到WordP […]

  • wordpress有必要在body内加<body <?php body_class(); ?>吗?
  • 是 WordPress 主题开发中非常有用的一部分,建议保留。它会自动输出一些根据页面类型、用户状态、文章分类 […]