Useful MySQL select and update

mysql-select-update.sql

/* find all matches for strings starting with 2070 in the fire_date column of the termmeta table */
SELECT * FROM `as9g6f0_termmeta` WHERE `meta_key` LIKE 'fire_date' AND `meta_value` LIKE '2070%';

/* find all matches for strings starting with 2070 in the fire_date column of the termmeta table and replace them with 1970 */
UPDATE as9g6f0_termmeta
SET meta_value = REPLACE(meta_value,'2070','1970')
WHERE `meta_key` LIKE 'fire_date' AND `meta_value` LIKE '2070%';