delete wordpress posts by category

delete wordpress posts by category

SELECT p.post_title, p.ID, wpr.object_id, wp_terms.term_id, wp_terms.name, wp_term_taxonomy.taxonomy
		FROM wp_terms
		INNER JOIN wp_term_taxonomy ON wp_terms.term_id = wp_term_taxonomy.term_id
		INNER JOIN wp_term_relationships wpr ON wpr.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
		INNER JOIN wp_posts p ON p.ID = wpr.object_id
		WHERE taxonomy =  'category'
		AND p.post_type =  'post'
		AND p.post_status =  'publish'
    AND name != 'Code'
    ORDER BY object_id;

DELETE 
FROM p using wp_terms
		INNER JOIN wp_term_taxonomy ON wp_terms.term_id = wp_term_taxonomy.term_id
		INNER JOIN wp_term_relationships wpr ON wpr.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
		INNER JOIN wp_posts p ON p.ID = wpr.object_id
		WHERE taxonomy =  'category'
		AND p.post_type =  'post'
		AND p.post_status =  'publish'
    AND name = 'Meals';