MySQL字符串函数相当于PHP ucwords()函数[重复]

可能的重复：
MySQL - 在现有表中将每个单词的第一个字母大写 https://stackoverflow.com/questions/3278207/mysql-capitalize-first-letter-of-each-word-in-existing-table

MySQL 是否有相当于 PHP 的 String 函数ucwords() http://php.net/manual/en/function.ucwords.php功能。

最终目标是使用 MySQL 将字符串中每个单词的第一个字母大写。

例子。

-- The name field in the table holds "JOHN DOE"
SELECT LOWER(name)
  FROM table

这会给我结果'john doe'

我想要的结果是'John Doe'

本文向您展示如何在 MySQL 中定义适当的案例：.

包括在链接失效的情况下：

DROP FUNCTION IF EXISTS proper; 
SET GLOBAL  log_bin_trust_function_creators=TRUE; 
DELIMITER | 
CREATE FUNCTION proper( str VARCHAR(128) ) 
RETURNS VARCHAR(128) 
BEGIN 
  DECLARE c CHAR(1); 
  DECLARE s VARCHAR(128); 
  DECLARE i INT DEFAULT 1; 
  DECLARE bool INT DEFAULT 1; 
  DECLARE punct CHAR(18) DEFAULT ' ()[]{},.-_\'!@;:?/'; -- David Rabby & Lenny Erickson added \' 
  SET s = LCASE( str ); 
  WHILE i <= LENGTH( str ) DO -- Jesse Palmer corrected from < to <= for last char 
    BEGIN 
      SET c = SUBSTRING( s, i, 1 ); 
      IF LOCATE( c, punct ) > 0 THEN 
        SET bool = 1; 
      ELSEIF bool=1 THEN  
        BEGIN 
          IF c >= 'a' AND c <= 'z' THEN  
            BEGIN 
              SET s = CONCAT(LEFT(s,i-1),UCASE(c),SUBSTRING(s,i+1)); 
              SET bool = 0; 
            END; 
          ELSEIF c >= '0' AND c <= '9' THEN 
            SET bool = 0; 
          END IF; 
        END; 
      END IF; 
      SET i = i+1; 
    END; 
  END WHILE; 
  RETURN s; 
END; 
| 
DELIMITER ; 
select proper("d'arcy"); 
+------------------+ 
| proper("d'arcy") | 
+------------------+ 
| D'Arcy           | 
+------------------+