Uppercase the first character of each word in a string using this MySQL custom function.

ucwords.sql

FUNCTION `ucwords`(input VARCHAR(255)) RETURNS varchar(255) CHARSET utf8 COLLATE utf8_spanish_ci
  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