Difference between revisions of "SQL Command to Update Announcement Color for WordPress"
Jump to navigation
Jump to search
m |
m |
||
| Line 1: | Line 1: | ||
To change an announcement color "in bulk", use the following command;<syntaxhighlight lang="text"> | To change an announcement color "in bulk", use the following command;<syntaxhighlight lang="text"> | ||
UPDATE | UPDATE wp_postmeta | ||
SET | SET meta_value = '#WhatEverHexColor' | ||
WHERE | WHERE meta_key = 'announcement_color'; | ||
NOTE: WhatEverHexColor should be a six character RGB color code. | NOTE: WhatEverHexColor should be a six character RGB color code. | ||
</syntaxhighlight>This can be applied to other values as well. | </syntaxhighlight>This can be applied to other values as well. | ||
Latest revision as of 17:12, 6 February 2020
To change an announcement color "in bulk", use the following command;
UPDATE wp_postmeta
SET meta_value = '#WhatEverHexColor'
WHERE meta_key = 'announcement_color';
NOTE: WhatEverHexColor should be a six character RGB color code.This can be applied to other values as well.