Evri charge SQL statements

evri_location_charge.sql

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 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'FK18 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'FK19 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'FK20 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'FK21 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'FK22 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'HS%';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'IM%';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'IV%';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'KA27 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'KA28 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'KW%';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA17 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA18 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA20 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA21 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA22 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA23 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA24 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA25 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA26 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA27 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA28 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA29 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA30 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA31 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA32 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA33 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA34 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA35 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA36 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA37 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA38 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA41 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA42 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA43 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA44 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA45 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA46 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA47 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA48 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA49 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA50 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA51 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA52 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA53 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA54 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA55 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA56 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA57 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA58 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA59 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA60 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA61 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA62 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA63 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA64 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA65 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA66 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA67 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA68 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA69 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA70 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA71 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA72 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA73 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA74 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA75 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA76 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA77 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA78 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA79 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PA80 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH3 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH5 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH6 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH7 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH10 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH11 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH13 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH14 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH15 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH16 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH17 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH18 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH19 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH20 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH31 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH32 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH33 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH34 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH35 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH36 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH37 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH38 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH39 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH40 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH41 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH42 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH43 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH44 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH45 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH46 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH47 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH48 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH49 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PH50 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PO30 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PO31 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PO32 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PO33 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PO35 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PO36 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PO37 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PO38 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PO39 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PO40 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'PO41 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'TR21 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'TR22 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'TR23 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'TR24 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'TR25 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'ZE%';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'BT%';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'JE%';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'GY%';