chrisastley

dir /b> files.txt
="UPDATE `data_templates` SET `changed` = NOW() WHERE `middleton_code` LIKE "&SUBSTITUTE(A1, ".svg", "")&";"
="UPDATE `data_templates` SET `changed` = `changed`, `enabled` = 1 WHERE `enabled` = 2 AND `middleton_code` LIKE "&SUBSTITUTE(A1, ".svg", "")&";"


UPDATE `ukvehicledata_map` SET `UvidList` = replace(`UvidList`, ' | ', '|A');
UPDATE `ukvehicledata_map` SET `UvidList` = CONCAT('|A', `UvidList`, '|');

SELECT * FROM `data_templates` WHERE `middleton_code` = 'tbc' AND `is_coming_soon` != 1;