Advanced Search

MySQL Proper Case Function

/ Published in: MySQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. DROP FUNCTION IF EXISTS proper;
  2. SET GLOBAL  log_bin_trust_function_creators=TRUE;
  3. DELIMITER |
  4. CREATE FUNCTION proper( str VARCHAR(128) )
  5. RETURNS VARCHAR(128)
  6. BEGIN
  7.   DECLARE c CHAR(1);
  8.   DECLARE s VARCHAR(128);
  9.   DECLARE i INT DEFAULT 1;
  10.   DECLARE bool INT DEFAULT 1;
  11.   DECLARE punct CHAR(17) DEFAULT ' ()[]{},.-_!@;:?/';
  12.   SET s = LCASE( str );
  13.   WHILE i < LENGTH( str ) DO 
  14.     BEGIN
  15.       SET c = SUBSTRING( s, i, 1 );
  16.       IF LOCATE( c, punct ) > 0 THEN
  17.         SET bool = 1;
  18.       ELSEIF bool=1 THEN 
  19.         BEGIN
  20.           IF c >= 'a' AND c <= 'z' THEN 
  21.             BEGIN
  22.               SET s = CONCAT(LEFT(s,i-1),UCASE(c),SUBSTRING(s,i+1));
  23.               SET bool = 0;
  24.             END;
  25.           ELSEIF c >= '0' AND c <= '9' THEN
  26.             SET bool = 0;
  27.           END IF;
  28.         END;
  29.       END IF;
  30.       SET i = i+1;
  31.     END;
  32.   END WHILE;
  33.   RETURN s;
  34. END;
  35. |
  36. DELIMITER ;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.