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;

chrisastley

UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 0;
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB35 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB36 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB37 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB38 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB53 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB54 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB55 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB56 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'FK17 %';