批量删除文章，按标题内容字段字段长短,
|
1 2 3 |
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 |
|
1 2 3 4 5 6 7 8 9 10 |
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 |
