Last active
April 20, 2017 06:47
-
-
Save n8finch/7296dd92f9d120577411c426d98047a1 to your computer and use it in GitHub Desktop.
SQL query samples.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT meta_key, meta_value | |
FROM wp_postmeta | |
WHERE meta_key = "issue_id" | |
But I need to only do posts with a category of | |
UPDATE wp_postmeta SET meta_value = '0' WHERE meta_value = '1'; | |
UPDATE eccklive_usermeta SET meta_value = 'Associate Membership' WHERE meta_value = 'Associate Corporate Membership'; UPDATE eccklive_usermeta SET meta_key = 'other_business_sector' WHERE meta_key = 166; UPDATE eccklive_usermeta SET meta_key = 'member_first_name' WHERE meta_key = 193; | |
SELECT meta_id, post_id, meta_key, meta_value | |
FROM wp_postmeta | |
WHERE meta_key = "issue_id"; | |
UPDATE wp_postmeta SET meta_value = 0 WHERE meta_value > 0; | |
UPDATE wp_postmeta SET meta_value = 33 WHERE meta_value > 0; | |
SELECT object_id, term_taxonomy_id | |
FROM wp_term_relationships | |
WHERE term_taxonomy_id = 9; | |
SELECT wp_term_relationships.term_taxonomy_id, wp_term_relationships.object_id, wp_postmeta.post_id, wp_postmeta.meta_key, wp_postmeta.meta_value | |
FROM wp_term_relationships | |
JOIN wp_postmeta | |
ON wp_postmeta.post_id=wp_term_relationships.object_id | |
WHERE term_taxonomy_id = 9 AND meta_key = 'issue_id' AND meta_value != 0; | |
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; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment