Z-blogPHP uses the sql command to delete articles published by specified users in batches

When we want to delete an article published by a specified user in the background of the website, we often try to delete this user, but after deleting this user, the article published by the user will still exist.

So how to delete articles published by specified users in batches?

we canphpMyAdmin Control PanelSQL commandDelete.

The sql command is as follows:

DELETE FROM zbp_post WHERE log_AuthorID = (SELECT mem_ID FROM zbp_member WHERE mem_Name = '用户名称');

The usage method is as shown in the following figure:

Just change the "user name" to your actual user name.