MySQL将查询的首字母大写

原查询：

root@tennis 11:07  mysql>select DIVISION from tennis.teams;
+----------+
| DIVISION |
+----------+
| first    |
| second   |
| third    |
| fourth   |
| fourth   |
| sixth    |
+----------+
6 rows in set (0.00 sec)
 

方法1：

使用left函数指定首字母

使用replace函数和upper函数将首字母改为大写

root@tennis 10:44  mysql>select replace(DIVISION,left(DIVISION,1),upper(left(DIVISION,1))) as division from teams;

查询结果:

root@tennis 14:35  mysql>select replace(DIVISION,left(DIVISION,1),upper(left(DIVISION,1))) as division from teams;
+----------+
| division |
+----------+
| First    |
| Second   |
| Third    |
| Fourth   |
| Fourth   |
| Sixth    |
+----------+
6 rows in set (0.00 sec)

方法2：

使用left