SQL语句：wordpress中删除某个作者的所有文章及数据

1、查找某个作者在wp_user表中的ID
SELECT * FROM wp_users WHERE display_name = '管理员';
如有需要也可以用模糊查找
SELECT * FROM wp_users WHERE display_name LIKE '%管理员%';

2、删除作者在wp_postmeta表中的所有信息，其中post_author为作者在wp_user表中的ID
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_author = '888');

3、删除作者在wp_posts表中的所有文章
DELETE FROM wp_posts WHERE post_author = '888';

4、删除作者在wp_usermeta表中的所有信息
DELETE FROM wp_usermeta WHERE user_id = '888';

5、最后删除作者在wp_users表中信息
DELETE FROM wp_users WHERE ID = '888'

2345步骤整合：
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_author = '888');
DELETE FROM wp_posts WHERE post_author = '888';
DELETE FROM wp_usermeta WHERE user_id = '888';
DELETE FROM wp_users WHERE ID = '888'