bmakowski/query.sql

Created May 13, 2018 14:43

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/bmakowski/4c801c95a78920603a66b8c3e225e6c0.js"></script>
Save bmakowski/4c801c95a78920603a66b8c3e225e6c0 to your computer and use it in GitHub Desktop.

Download ZIP

Wordpress SQL Delete Custom Post Types and Meta

Raw

	delete
	p,pm
	from wp_posts p
	join wp_postmeta pm on pm.post_id = p.id
	where p.post_type = 'companies'

Author

bmakowski commented May 13, 2018

Replace 'companies' with custom post type slug.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment