Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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) REGEXP BINARY '[^0-9A-z]') 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;
Add Comment
Please, Sign In to add comment