CPT: match custom field: played
Is it possible by MySql to change the status from publish to draft of all posts of CPT 'match' with custom field set as '0'?
A good start can be
UPDATE wp_posts SET post_status = 'draft' WHERE post_type = 'match' AND meta_key = 'played' AND meta_value = 0;
meta_value are not in
Thanks a lot for your support