SQL Command to Update Announcement Color for WordPress

Wiki.TerraBase.info
Revision as of 18:26, 30 January 2020 by Root (talk | contribs)
Jump to navigation Jump to search

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.