CREATE TABLE IF NOT EXISTS area (
	iso CHAR(6) NOT NULL PRIMARY KEY,
	name VARCHAR(80) NOT NULL,
);

INSERT INTO area VALUES ('GB-ABD','Aberdeenshire');
INSERT INTO area VALUES ('GB-ABE','Aberdeen');
INSERT INTO area VALUES ('GB-AGB','Argyll and Bute');
INSERT INTO area VALUES ('GB-AGY','Isle of Anglesey');
INSERT INTO area VALUES ('GB-ANS','Angus');
INSERT INTO area VALUES ('GB-ANT','Antrim');
INSERT INTO area VALUES ('GB-ARD','Ards');
INSERT INTO area VALUES ('GB-ARM','Armagh');
INSERT INTO area VALUES ('GB-BAS','Bath and North East Somerset (unitary authority)');
INSERT INTO area VALUES ('GB-BBD','Blackburn with Darwen (unitary authority)');
INSERT INTO area VALUES ('GB-BDF','Bedfordshire (county)');
INSERT INTO area VALUES ('GB-BDG','Barking and Dagenham (London borough)');
INSERT INTO area VALUES ('GB-BEN','Brent (London borough)');
INSERT INTO area VALUES ('GB-BEX','Bexley (London borough)');
INSERT INTO area VALUES ('GB-BFS','Belfast');
INSERT INTO area VALUES ('GB-BGE','Bridgend');
INSERT INTO area VALUES ('GB-BGW','Blaenau Gwent');
INSERT INTO area VALUES ('GB-BIR','Birmingham (West Midlands district)');
INSERT INTO area VALUES ('GB-BKM','Buckinghamshire (county)');
INSERT INTO area VALUES ('GB-BLA','Ballymena');
INSERT INTO area VALUES ('GB-BLY','Ballymoney');
INSERT INTO area VALUES ('GB-BMH','Bournemouth (unitary authority)');
INSERT INTO area VALUES ('GB-BNB','Banbridge');
INSERT INTO area VALUES ('GB-BNE','Barnet (London borough)');
INSERT INTO area VALUES ('GB-BNH','Brighton and Hove (unitary authority)');
INSERT INTO area VALUES ('GB-BNS','Barnsley (South Yorkshire district)');
INSERT INTO area VALUES ('GB-BOL','Bolton (Greater Manchester district)');
INSERT INTO area VALUES ('GB-BPL','Blackpool (unitary authority)');
INSERT INTO area VALUES ('GB-BRC','Bracknell Forest (unitary authority)');
INSERT INTO area VALUES ('GB-BRD','Bradford (West Yorkshire district)');
INSERT INTO area VALUES ('GB-BRY','Bromley (London borough)');
INSERT INTO area VALUES ('GB-BST','Bristol, City of (unitary authority)');
INSERT INTO area VALUES ('GB-BUR','Bury (Greater Manchester district)');
INSERT INTO area VALUES ('GB-CAM','Cambridgeshire (county)');
INSERT INTO area VALUES ('GB-CAY','Caerphilly');
INSERT INTO area VALUES ('GB-CGN','Ceredigion');
INSERT INTO area VALUES ('GB-CGV','Craigavon');
INSERT INTO area VALUES ('GB-CHS','Cheshire (county)');
INSERT INTO area VALUES ('GB-CKF','Carrickfergus');
INSERT INTO area VALUES ('GB-CKT','Cookstown');
INSERT INTO area VALUES ('GB-CLD','Calderdale (West Yorkshire district)');
INSERT INTO area VALUES ('GB-CLK','Clackmannanshire');
INSERT INTO area VALUES ('GB-CLR','Coleraine');
INSERT INTO area VALUES ('GB-CMA','Cumbria (county)');
INSERT INTO area VALUES ('GB-CMD','Camden (London borough)');
INSERT INTO area VALUES ('GB-CMN','Carmarthenshire');
INSERT INTO area VALUES ('GB-CON','Cornwall (county)');
INSERT INTO area VALUES ('GB-COV','Coventry (West Midlands district)');
INSERT INTO area VALUES ('GB-CRF','Cardiff');
INSERT INTO area VALUES ('GB-CRY','Croydon (London borough)');
INSERT INTO area VALUES ('GB-CSR','Castlereagh');
INSERT INTO area VALUES ('GB-CWY','Conwy');
INSERT INTO area VALUES ('GB-DAL','Darlington (unitary authority)');
INSERT INTO area VALUES ('GB-DBY','Derbyshire (county)');
INSERT INTO area VALUES ('GB-DEN','Denbighshire');
INSERT INTO area VALUES ('GB-DER','Derby (unitary authority)');
INSERT INTO area VALUES ('GB-DEV','Devon (county)');
INSERT INTO area VALUES ('GB-DGN','Dungannon and South Tyrone');
INSERT INTO area VALUES ('GB-DGY','Dumfries and Galloway');
INSERT INTO area VALUES ('GB-DNC','Doncaster (South Yorkshire district)');
INSERT INTO area VALUES ('GB-DND','Dundee');
INSERT INTO area VALUES ('GB-DOR','Dorset (county)');
INSERT INTO area VALUES ('GB-DOW','Down');
INSERT INTO area VALUES ('GB-DRY','Derry');
INSERT INTO area VALUES ('GB-DUD','Dudley (West Midlands district)');
INSERT INTO area VALUES ('GB-DUR','Durham (county)');
INSERT INTO area VALUES ('GB-EAL','Ealing (London borough)');
INSERT INTO area VALUES ('GB-EAY','East Ayrshire');
INSERT INTO area VALUES ('GB-EDH','Edinburgh');
INSERT INTO area VALUES ('GB-EDU','East Dunbartonshire');
INSERT INTO area VALUES ('GB-ELN','East Lothian');
INSERT INTO area VALUES ('GB-ELS','Eilean Siar');
INSERT INTO area VALUES ('GB-ENF','Enfield (London borough)');
INSERT INTO area VALUES ('GB-ERW','East Renfrewshire');
INSERT INTO area VALUES ('GB-ERY','East Riding of Yorkshire (unitary authority)');
INSERT INTO area VALUES ('GB-ESS','Essex (county)');
INSERT INTO area VALUES ('GB-ESX','East Sussex (county)');
INSERT INTO area VALUES ('GB-FAL','Falkirk');
INSERT INTO area VALUES ('GB-FER','Fermanagh');
INSERT INTO area VALUES ('GB-FIF','Fife');
INSERT INTO area VALUES ('GB-FLN','Flintshire');
INSERT INTO area VALUES ('GB-GAT','Gateshead (Tyne & Wear district)');
INSERT INTO area VALUES ('GB-GLG','Glasgow');
INSERT INTO area VALUES ('GB-GLS','Gloucestershire (county)');
INSERT INTO area VALUES ('GB-GRE','Greenwich (London borough)');
INSERT INTO area VALUES ('GB-GSY','Guernsey');
INSERT INTO area VALUES ('GB-GWN','Gwynedd');
INSERT INTO area VALUES ('GB-HAL','Halton (unitary authority)');
INSERT INTO area VALUES ('GB-HAM','Hampshire (county)');
INSERT INTO area VALUES ('GB-HAV','Havering (London borough)');
INSERT INTO area VALUES ('GB-HCK','Hackney (London borough)');
INSERT INTO area VALUES ('GB-HEF','Herefordshire, County of (unitary authority)');
INSERT INTO area VALUES ('GB-HIL','Hillingdon (London borough)');
INSERT INTO area VALUES ('GB-HLD','Highland');
INSERT INTO area VALUES ('GB-HMF','Hammersmith and Fulham (London borough)');
INSERT INTO area VALUES ('GB-HNS','Hounslow (London borough)');
INSERT INTO area VALUES ('GB-HPL','Hartlepool (unitary authority)');
INSERT INTO area VALUES ('GB-HRT','Hertfordshire (county)');
INSERT INTO area VALUES ('GB-HRW','Harrow (London borough)');
INSERT INTO area VALUES ('GB-HRY','Haringey (London borough)');
INSERT INTO area VALUES ('GB-IOS','Isles of Scilly (special area)');
INSERT INTO area VALUES ('GB-IOW','Isle of Wight (unitary authority)');
INSERT INTO area VALUES ('GB-ISL','Islington (London borough)');
INSERT INTO area VALUES ('GB-IVC','Inverclyde');
INSERT INTO area VALUES ('GB-JSY','Jersey');
INSERT INTO area VALUES ('GB-KEC','Kensington and Chelsea (London borough)');
INSERT INTO area VALUES ('GB-KEN','Kent (county)');
INSERT INTO area VALUES ('GB-KHL','Kingston upon Hull, City of (unitary authority)');
INSERT INTO area VALUES ('GB-KIR','Kirklees (West Yorkshire district)');
INSERT INTO area VALUES ('GB-KTT','Kingston upon Thames (London borough)');
INSERT INTO area VALUES ('GB-KWL','Knowsley (Merseyside district)');
INSERT INTO area VALUES ('GB-LAN','Lancashire (county)');
INSERT INTO area VALUES ('GB-LBH','Lambeth (London borough)');
INSERT INTO area VALUES ('GB-LCE','Leicester (unitary authority)');
INSERT INTO area VALUES ('GB-LDS','Leeds (West Yorkshire district)');
INSERT INTO area VALUES ('GB-LEC','Leicestershire (county)');
INSERT INTO area VALUES ('GB-LEW','Lewisham (London borough)');
INSERT INTO area VALUES ('GB-LIN','Lincolnshire (county)');
INSERT INTO area VALUES ('GB-LIV','Liverpool (Merseyside district)');
INSERT INTO area VALUES ('GB-LMV','Limavady');
INSERT INTO area VALUES ('GB-LND','London, City of (london borough)');
INSERT INTO area VALUES ('GB-LRN','Larne');
INSERT INTO area VALUES ('GB-LSB','Lisburn');
INSERT INTO area VALUES ('GB-LUT','Luton (unitary authority)');
INSERT INTO area VALUES ('GB-MAN','Manchester (Greater Manchester district)');
INSERT INTO area VALUES ('GB-MDB','Middlesbrough (unitary authority)');
INSERT INTO area VALUES ('GB-MDW','Medway (unitary authority)');
INSERT INTO area VALUES ('GB-MFT','Magherafelt');
INSERT INTO area VALUES ('GB-MIK','Milton Keynes (unitary authority)');
INSERT INTO area VALUES ('GB-MLN','Midlothian');
INSERT INTO area VALUES ('GB-MON','Monmouthshire');
INSERT INTO area VALUES ('GB-MRT','Merton (London borough)');
INSERT INTO area VALUES ('GB-MRY','Moray');
INSERT INTO area VALUES ('GB-MTY','Merthyr Tydfil');
INSERT INTO area VALUES ('GB-MYL','Moyle');
INSERT INTO area VALUES ('GB-NAY','North Ayrshire');
INSERT INTO area VALUES ('GB-NBL','Northumberland (county)');
INSERT INTO area VALUES ('GB-NDN','North Down');
INSERT INTO area VALUES ('GB-NEL','North East Lincolnshire (unitary authority)');
INSERT INTO area VALUES ('GB-NET','Newcastle upon Tyne (Tyne & Wear district)');
INSERT INTO area VALUES ('GB-NFK','Norfolk (county)');
INSERT INTO area VALUES ('GB-NGM','Nottingham (unitary authority)');
INSERT INTO area VALUES ('GB-NLK','North Lanarkshire');
INSERT INTO area VALUES ('GB-NLN','North Lincolnshire (unitary authority)');
INSERT INTO area VALUES ('GB-NSM','North Somerset (unitary authority)');
INSERT INTO area VALUES ('GB-NTA','Newtownabbey');
INSERT INTO area VALUES ('GB-NTH','Northamptonshire (county)');
INSERT INTO area VALUES ('GB-NTL','Neath Port Talbot');
INSERT INTO area VALUES ('GB-NTT','Nottinghamshire (county)');
INSERT INTO area VALUES ('GB-NTY','North Tyneside (Tyne & Wear district)');
INSERT INTO area VALUES ('GB-NWM','Newham (London borough)');
INSERT INTO area VALUES ('GB-NWP','Newport');
INSERT INTO area VALUES ('GB-NYK','North Yorkshire (county)');
INSERT INTO area VALUES ('GB-NYM','Newry and Mourne');
INSERT INTO area VALUES ('GB-OLD','Oldham (Greater Manchester district)');
INSERT INTO area VALUES ('GB-OMH','Omagh');
INSERT INTO area VALUES ('GB-ORK','Orkney Islands');
INSERT INTO area VALUES ('GB-OXF','Oxfordshire (county)');
INSERT INTO area VALUES ('GB-PEM','Pembrokeshire');
INSERT INTO area VALUES ('GB-PKN','Perth and Kinross');
INSERT INTO area VALUES ('GB-PLY','Plymouth (unitary authority)');
INSERT INTO area VALUES ('GB-POL','Poole (unitary authority)');
INSERT INTO area VALUES ('GB-POR','Portsmouth (unitary authority)');
INSERT INTO area VALUES ('GB-POW','Powys');
INSERT INTO area VALUES ('GB-PTE','Peterborough (unitary authority)');
INSERT INTO area VALUES ('GB-RCC','Redcar and Cleveland (unitary authority)');
INSERT INTO area VALUES ('GB-RCH','Rochdale (Greater Manchester district)');
INSERT INTO area VALUES ('GB-RCT','Rhondda Cynon Taf');
INSERT INTO area VALUES ('GB-RDB','Redbridge (London borough)');
INSERT INTO area VALUES ('GB-RDG','Reading (unitary authority)');
INSERT INTO area VALUES ('GB-RFW','Renfrewshire');
INSERT INTO area VALUES ('GB-RIC','Richmond upon Thames (London borough)');
INSERT INTO area VALUES ('GB-ROT','Rotherham (South Yorkshire district)');
INSERT INTO area VALUES ('GB-RUT','Rutland (unitary authority)');
INSERT INTO area VALUES ('GB-SAW','Sandwell (West Midlands district)');
INSERT INTO area VALUES ('GB-SAY','South Ayrshire');
INSERT INTO area VALUES ('GB-SCB','Scottish Borders, The');
INSERT INTO area VALUES ('GB-SFK','Suffolk (county)');
INSERT INTO area VALUES ('GB-SFT','Sefton (Merseyside district)');
INSERT INTO area VALUES ('GB-SGC','South Gloucestershire (unitary authority)');
INSERT INTO area VALUES ('GB-SHF','Sheffield (South Yorkshire district)');
INSERT INTO area VALUES ('GB-SHN','St Helens (Merseyside district)');
INSERT INTO area VALUES ('GB-SHR','Shropshire (county)');
INSERT INTO area VALUES ('GB-SKP','Stockport (Greater Manchester district)');
INSERT INTO area VALUES ('GB-SLF','Salford (Greater Manchester district)');
INSERT INTO area VALUES ('GB-SLG','Slough (unitary authority)');
INSERT INTO area VALUES ('GB-SLK','South Lanarkshire');
INSERT INTO area VALUES ('GB-SND','Sunderland (Tyne & Wear district)');
INSERT INTO area VALUES ('GB-SOL','Solihull (West Midlands district)');
INSERT INTO area VALUES ('GB-SOM','Somerset (county)');
INSERT INTO area VALUES ('GB-SOS','Southend-on-Sea (unitary authority)');
INSERT INTO area VALUES ('GB-SRY','Surrey (county)');
INSERT INTO area VALUES ('GB-STB','Strabane');
INSERT INTO area VALUES ('GB-STE','Stoke-on-Trent (unitary authority)');
INSERT INTO area VALUES ('GB-STG','Stirling');
INSERT INTO area VALUES ('GB-STH','Southampton (unitary authority)');
INSERT INTO area VALUES ('GB-STN','Sutton (London borough)');
INSERT INTO area VALUES ('GB-STS','Staffordshire (county)');
INSERT INTO area VALUES ('GB-STT','Stockton-on-Tees (unitary authority)');
INSERT INTO area VALUES ('GB-STY','South Tyneside (Tyne & Wear district)');
INSERT INTO area VALUES ('GB-SWA','Swansea');
INSERT INTO area VALUES ('GB-SWD','Swindon (unitary authority)');
INSERT INTO area VALUES ('GB-SWK','Southwark (London borough)');
INSERT INTO area VALUES ('GB-TAM','Tameside (Greater Manchester district)');
INSERT INTO area VALUES ('GB-TFW','Telford and Wrekin (unitary authority)');
INSERT INTO area VALUES ('GB-THR','Thurrock (unitary authority)');
INSERT INTO area VALUES ('GB-TOB','Torbay (unitary authority)');
INSERT INTO area VALUES ('GB-TOF','Torfaen');
INSERT INTO area VALUES ('GB-TRF','Trafford (Greater Manchester district)');
INSERT INTO area VALUES ('GB-TWH','Tower Hamlets (London borough)');
INSERT INTO area VALUES ('GB-VGL','Vale of Glamorgan');
INSERT INTO area VALUES ('GB-WAR','Warwickshire (county)');
INSERT INTO area VALUES ('GB-WBK','West Berkshire (unitary authority)');
INSERT INTO area VALUES ('GB-WDU','West Dunbartonshire');
INSERT INTO area VALUES ('GB-WFT','Waltham Forest (London borough)');
INSERT INTO area VALUES ('GB-WGN','Wigan (Greater Manchester district)');
INSERT INTO area VALUES ('GB-WIL','Wiltshire (county)');
INSERT INTO area VALUES ('GB-WKF','Wakefield (West Yorkshire district)');
INSERT INTO area VALUES ('GB-WLL','Walsall (West Midlands district)');
INSERT INTO area VALUES ('GB-WLN','West Lothian');
INSERT INTO area VALUES ('GB-WLV','Wolverhampton (West Midlands district)');
INSERT INTO area VALUES ('GB-WND','Wandsworth (London borough)');
INSERT INTO area VALUES ('GB-WNM','Windsor and Maidenhead (unitary authority)');
INSERT INTO area VALUES ('GB-WOK','Wokingham (unitary authority)');
INSERT INTO area VALUES ('GB-WOR','Worcestershire (county)');
INSERT INTO area VALUES ('GB-WRL','Wirral (Merseyside district)');
INSERT INTO area VALUES ('GB-WRT','Warrington (unitary authority)');
INSERT INTO area VALUES ('GB-WRX','Wrexham');
INSERT INTO area VALUES ('GB-WSM','Westminster (London borough)');
INSERT INTO area VALUES ('GB-WSX','West Sussex (county)');
INSERT INTO area VALUES ('GB-YOR','York (unitary authority)');
INSERT INTO area VALUES ('GB-ZET','Shetland Islands');

SHOW CREATE DATABASE `DB_NAME`;

SELECT email, 
 COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )

SELECT IF(INSTR( `textfield`, ' ' ) > 0, SUBSTRING( `textfield` FROM 1 FOR (INSTR( `textfield`, ' ' ) -1 )), `textfield`) FROM `exampletable`;

SELECT foo, bar 
FROM mytable
GROUP BY foo, bar
HAVING COUNT(*)>1;

delete from wp_posts where ID in (select wp_term_relationships.object_id from wp_term_relationships
left join wp_term_taxonomy on wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
left join wp_terms on wp_term_taxonomy.term_id = wp_terms.term_id
where wp_terms.term_id = 3);

ALTER TABLE `table_name_here` AUTO_INCREMENT =0

alter table t1, change id id int (11) DEFAULT '0' NOT NULL, drop primary key;
ALTER TABLE table ADD id2 INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (id2);
alter table t1, change id2 id2 int (10)  NULL, drop primary key;
alter table t1, change id id int (11)UNSIGNED  DEFAULT '0' NOT NULL AUTO_INCREMENT, add primary key(id);

ALTER TABLE residents_resident AUTO_INCREMENT = 100;

ALTER TABLE tablename AUTO_INCREMENT = 1