MySQL

mysql: capitalize first word of all words

credits to: http://joezack.com/2008/10/20/mysql-capitalize-function/

 

create a function:

 

CREATE FUNCTION CAP_FIRST (input VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC BEGIN DECLARE len INT;

DECLARE i INT;

SET
len = CHAR_LENGTH(input);

SET
input = LOWER(input);

SET
i = 0;

WHILE (i < len) DO IF (MID(input, i, 1) = ' '
OR i = 0) THEN IF (i < len) THEN SET
input = CONCAT( LEFT(input, i), UPPER(MID(input, i + 1, 1)), RIGHT(input, len - i - 1) );
END IF;
END IF;

SET
i = i + 1;
END WHILE;

RETURN input;
END;

 

 


great solution, although this should come native from the mysql core

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *