SQL Command to Update Announcement Color for WordPress

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.