0
to change the first letters of a single column to capital
3 odpowiedzi
0
select concat(upper(mid(columnchange,1,1)),mid(columnchange,2)) from thetable
0
select concat(upper(substr(column,1,1)), substr(column,2)) from table
0
SELECT CONCAT(UPPER(LEFT(column,1)),RIGHT(column,LENGTH(column)-1)) FROM table