
SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE('', '', 'a'), '', 'o'), '', 'e'), '', 'e'), '', 'c'), '', 'e'), '', 'u');

INSERT INTO locations (`id`,`regid`,`ccid`,`name`,`lat`,`long`)
SELECT
`id` + 10000,
`regid`, `ccid`, 
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`name`, '', 'a'), '', 'o'), '', 'e'), '', 'e'), '', 'c'), '', 'e'), '', 'u'), '', 'a'), '', 'E'), '', 'i'), '', 'e'),
`lat`, `long`
FROM locations
where id between 7900000 and 79099999;

UPDATE regions
set
`name` = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`name`, '', 'a'), '', 'o'), '', 'e'), '', 'e'), '', 'c'), '', 'e'), '', 'u'), '', 'a'), '', 'E'), '', 'i'), '', 'e')
where id between 79000 and 79999;


