quit_accents.function.sql

DROP FUNCTION `quit_accents`;
CREATE FUNCTION `quit_accents`(str longtext)
 RETURNS longtext CHARSET utf8
BEGIN
    DECLARE result LONGTEXT;
 
    SET result = str;
 
    SET result = REPLACE(result, 'á', 'a');
    SET result = REPLACE(result, 'é', 'e');
    SET result = REPLACE(result, 'í', 'i');
    SET result = REPLACE(result, 'ó', 'o');
    SET result = REPLACE(result, 'ú', 'u');
 
    SET result = REPLACE(result, 'Á', 'A');
    SET result = REPLACE(result, 'É', 'E');
    SET result = REPLACE(result, 'Í', 'I');
    SET result = REPLACE(result, 'Ó', 'O');
    SET result = REPLACE(result, 'Ú', 'U');
 
    SET result = REPLACE(result, 'ñ', 'n');
    SET result = REPLACE(result, 'Ñ', 'N');
 
    RETURN result;
END;;