ucwords di mysql

DELIMITER $$ CREATE FUNCTION ProperCase(str VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC BEGIN DECLARE i INT DEFAULT 1; DECLARE len INT DEFAULT CHAR_LENGTH(str); DECLARE result VARCHAR(255) DEFAULT ''; WHILE i <= len DO SET result = CONCAT(result, IF(i = 1 OR SUBSTRING(str, i - 1, 1) = ' ', UPPER(SUBSTRING(str, i, 1)), LOWER(SUBSTRING(str, i, 1))) ); SET i = i + 1; END WHILE; RETURN result; END $$ DELIMITER ; 

 UPDATE wilayah SET kabupaten = ProperCase(kabupaten);