网络营销电子商务研究中心

网络营销电子商务研究中心 (https://www.0058.net/index.php)
-   MySQL (https://www.0058.net/forumdisplay.php?f=76)
-   -   How could I turn the first letter of each entry to Uppercase letter? (https://www.0058.net/showthread.php?t=5062)

Hallam 2015-03-31 09:28 AM

How could I turn the first letter of each entry to Uppercase letter?
 
You can use a combination of UCASE(), MID() and CONCAT():

SELECT CONCAT(UCASE(MID(name,1,1)),MID(name,2)) AS name FROM names;


All times are GMT +8. The time now is 04:45 PM.

Powered by vBulletin Version 3.8.7
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.