Generate Alias

gistfile1.txt

UPDATE jos_content SET
alias = TRIM(title),
alias = REPLACE(REPLACE(REPLACE(title, '  ', '-'), ' ', '-'), '--', ''),
alias = UCASE(alias),
alias = REPLACE(alias, 'Á', 'A'),
alias = REPLACE(alias, 'À', 'A'), 
alias = REPLACE(alias, 'Ã', 'A'),  
alias = REPLACE(alias, 'Â', 'A'),  
alias = REPLACE(alias, 'É', 'E'),  
alias = REPLACE(alias, 'È', 'E'),  
alias = REPLACE(alias, 'Ê', 'E'),  
alias = REPLACE(alias, 'Í', 'I'),  
alias = REPLACE(alias, 'Ì', 'I'),  
alias = REPLACE(alias, 'Î', 'I'),  
alias = REPLACE(alias, 'Ó', 'O'),  
alias = REPLACE(alias, 'Ò', 'O'),  
alias = REPLACE(alias, 'Ô', 'O'),  
alias = REPLACE(alias, 'Õ', 'O'),  
alias = REPLACE(alias, 'Ú', 'U'),  
alias = REPLACE(alias, 'Ù', 'U'),  
alias = REPLACE(alias, 'Û', 'U'),  
alias = REPLACE(alias, 'Ü', 'U'),  
alias = REPLACE(alias, 'Ç', 'C'),
alias = REPLACE(alias, ')', ''),
alias = REPLACE(alias, '(', ''),
alias = REPLACE(alias, '\\', ''),
alias = REPLACE(alias, '/', ''),
alias = REPLACE(alias, '?', ''),
alias = REPLACE(alias, '!', ''),
alias = REPLACE(alias, 'º', ''),
alias = REPLACE(alias, '@', ''),
alias = REPLACE(alias, '#', ''),
alias = REPLACE(alias, '&', ''),
alias = REPLACE(alias, '*', ''),
alias = REPLACE(alias, '+', ''),
alias = REPLACE(alias, '"', ''),
alias = REPLACE(alias, '!', ''),
alias = REPLACE(alias, '%', ''),
alias = REPLACE(alias, '^', ''),
alias = REPLACE(alias, '~', ''),
alias = REPLACE(alias, '{', ''),
alias = REPLACE(alias, '}', ''),
alias = REPLACE(alias, ',', ''),
alias = REPLACE(alias, '.', ''),
alias = REPLACE(alias, 'ª', ''),
alias = REPLACE(alias, '“', ''),
alias = REPLACE(alias, '”', ''),
alias = REPLACE(alias, ':', ''),
alias = REPLACE(alias, '–', ''),
alias = REPLACE(alias, ' ', ''),
alias = LOWER(TRIM(alias))
WHERE alias = ''