MySQL Query – Delete all WooCommerce Bookings

If you need to delete all WooCommerce bookings that have the custom post type wc_booking you can use the MySQL query below:

SQL

DELETE FROM wpstg4_postmeta WHERE post_id IN ( SELECT ID FROM wpstg4_posts WHERE post_type = 'wc_booking' );<br> DELETE FROM wpstg4_posts WHERE post_type = 'wc_booking';