ucwords di mysql

ucwords atau propercase 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

Feb 23, 2025 - 12:52

ucwords atau propercase 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 ;

Kemudian jalankan query ini:


UPDATE wilayah
SET kabupaten = ProperCase(kabupaten);