How to update crisis support

1) Preview what will change

SELECT um.database_id, um.value, dp.post_filename FROM users_meta um JOIN data_posts dp ON dp.post_id = um.database_id WHERE um.key = 'crisis_support' AND dp.post_filename LIKE '%resources/%' AND LOWER(TRIM(um.value)) IN ('yes','no','true','false','on','off');

2) Normalize existing values

UPDATE users_meta um JOIN data_posts dp ON dp.post_id = um.database_id SET um.value = '1' WHERE um.key = 'crisis_support' AND dp.post_filename LIKE '%resources/%' AND LOWER(TRIM(um.value)) IN ('yes','true','on'); UPDATE users_meta um JOIN data_posts dp ON dp.post_id = um.database_id SET um.value = '0' WHERE um.key = 'crisis_support' AND dp.post_filename LIKE '%resources/%' AND LOWER(TRIM(um.value)) IN ('no','false','off','0','');

3) Insert missing rows as 0

INSERT INTO users_meta (`database`, database_id, `key`, `value`, date_added) SELECT 'data_posts', dp.post_id, 'crisis_support', '0', DATE_FORMAT(NOW(), '%Y%m%d%H%i%s') FROM data_posts dp LEFT JOIN users_meta um ON um.database_id = dp.post_id AND um.key = 'crisis_support' WHERE dp.post_filename LIKE '%resources/%' AND um.database_id IS NULL;