Random stuff about serendipity. Discussion, Questions, Paraphernalia.
- Posts: 2
- Joined: Sun Jul 26, 2020 4:51 am
- Location: Portland, Oregon
It seems this works:
Code: Select all
delete from <database_name>_entries where isdraft == 'true';
If there is a side effect, please let me know.
After importing WordPress entries I find a lot of Draft entries.
How can I bulk delete all of them? I am using the Sqlite database backend and am comfortable with manually doing it through the db interface.
If this is covered in the Documents, just tell me and I'll go find it.
MichaelRpdx - Be Appropriate && Follow Your Curiosity
- Posts: 2465
- Joined: Tue Sep 09, 2008 10:04 pm
You can also take care of this via the entry list. Filter for drafts (fitler icon at the top left), invert selection to mark all, then press delete.
- Posts: 1
- Joined: Tue Oct 20, 2020 6:50 am
Thanks guys. It was helpful