title_case.sql

    -- Function ("prepared statement") for MySQL, equivalent to PHPs ucwords --
    -- base off: https://brianloomis.wordpress.com/2009/10/15/working-with-titlecase-in-mysql/
    
    DROP FUNCTION IF EXISTS proper;
    SET GLOBAL log_bin_trust_function_creators=TRUE;
    DELIMITER |
    CREATE FUNCTION proper( str VARCHAR(128) )
    RETURNS VARCHAR(128)
    BEGIN
    DECLARE c CHAR(1);
    DECLARE s VARCHAR(128);
    DECLARE i INT DEFAULT 1;
    DECLARE bool INT DEFAULT 1;
    DECLARE punct CHAR(17) DEFAULT ' ()[]{},.-_!@;:?/';
    SET s = LCASE( str );
    WHILE i <= LENGTH( str ) DO
        BEGIN
    SET c = SUBSTRING( s, i, 1 );
    IF LOCATE( c, punct ) > 0 THEN
    SET bool = 1;
    ELSEIF bool=1 THEN
    BEGIN
    IF c >= 'a' AND c <= 'z' THEN
    BEGIN
    SET s = CONCAT(LEFT(s,i-1),UCASE(c),SUBSTRING(s,i+1));
    SET bool = 0;
    END;
    ELSEIF c >= '0' AND c <= '9' THEN
    SET bool = 0;
    END IF;
    END;
    END IF;
    SET i = i+1;
    END;
    END WHILE;
    RETURN s;
    END;
    |
    DELIMITER ;