Difference between revisions of "SQL Command to Update Announcement Color for WordPress"

Wiki.TerraBase.info
Jump to navigation Jump to search
(Created page with "<code>UPDATE wp_postmeta</code> <code>SET meta_value = '#000000'</code> <code>WHERE meta_key = 'announcement_color'</code>")
 
m
Line 1: Line 1:
<code>UPDATE wp_postmeta</code>
To change an announcement color "in bulk", use the following command;<syntaxhighlight lang="text">
UPDATE 'wp_postmeta'
SET 'meta_value' = '#WhatEverHexColor'
WHERE 'meta_key' = 'announcement_color';


<code>SET meta_value = '#000000'</code>
NOTE: WhatEverHexColor should be a six character RGB color code.
 
</syntaxhighlight>This can be applied to other values as well.
<code>WHERE meta_key = 'announcement_color'</code>

Revision as of 18:26, 30 January 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.

Retrieved from "https://wiki.terrabase.info/index.php?title=SQL_Command_to_Update_Announcement_Color_for_WordPress&oldid=350"