Advanced Search

Return to Snippet

Revision: 11146
at January 26, 2009 09:45 by ping_ch
Initial Code 
DELIMITER $$
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$$

DELIMITER ;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
MySQL Capitalize

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL