n8finch
3/20/2017 - 1:06 PM

UPDATE in SQL

UPDATE in SQL

UPDATE wp_postmeta AS a
JOIN wp_term_relationships AS b 
ON a.post_id=b.object_id 
SET meta_value=0
WHERE term_taxonomy_id = 9 AND meta_key = 'issue_id' AND meta_value != 0;