Thread: How could I turn the first letter of each entry to Uppercase letter?
View Single Post
  #1   IP: 112.87.93.182
Old 2015-03-31, 09:28 AM
Hallam Hallam is offline
初级会员
  
Join Date: 2013-11-25
Posts: 1
Hallam 现在声名狼藉
Default 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;
Reply With Quote