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;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;