資料結構
網路
關係資料庫管理系統
作業系統
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 程式語言
C++
C#
MongoDB
MySQL
Javascript
PHP
物理
化學
生物
數學
英語
經濟
心理學
社會學
時尚學
法學我們可以使用哪些 MySQL 函式來更改字串的大小寫？
我們可以使用 LCASE() 和 LOWER() 函式將字串的大小寫更改為小寫，使用 UCASE() 和 UPPER() 函式將字串的大小寫更改為大寫。
示例
mysql> Select LCASE('NEW DELHI');
+--------------------+
| LCASE('NEW DELHI') |
+--------------------+
| new delhi |
+--------------------+
1 row in set (0.00 sec)
mysql> Select LOWER('NEW DELHI');
+--------------------+
| LOWER('NEW DELHI') |
+--------------------+
| new delhi |
+--------------------+
1 row in set (0.00 sec)
mysql> Select UCASE('new delhi');
+--------------------+
| UCASE('new delhi') |
+--------------------+
| NEW DELHI |
+--------------------+
1 row in set (0.00 sec)
mysql> Select UPPER('new delhi');
+--------------------+
| UPPER('new delhi') |
+--------------------+
| NEW DELHI |
+--------------------+
1 row in set (0.00 sec)我們還可以在表的列中使用這些函式。例如，假設我們想更改輸出中某一列的值的大小寫，那麼對錶“Student”執行以下查詢即可實現：-
mysql> Select Name, UCASE(Name) from student; +---------+-------------+ | Name | UCASE(Name) | +---------+-------------+ | Gaurav | GAURAV | | Aarav | AARAV | | Harshit | HARSHIT | | Gaurav | GAURAV | | Yashraj | YASHRAJ | +---------+-------------+ 5 rows in set (0.00 sec) mysql> Select Name, LCASE(Name) from student; +---------+-------------+ | Name | LCASE(Name) | +---------+-------------+ | Gaurav | gaurav | | Aarav | aarav | | Harshit | harshit | | Gaurav | gaurav | | Yashraj | yashraj | +---------+-------------+ 5 rows in set (0.00 sec) mysql> Select Name, UPPER(Name) from student; +---------+-------------+ | Name | UPPER(Name) | +---------+-------------+ | Gaurav | GAURAV | | Aarav | AARAV | | Harshit | HARSHIT | | Gaurav | GAURAV | | Yashraj | YASHRAJ | +---------+-------------+ 5 rows in set (0.00 sec) mysql> Select Name, LOWER(Name) from student; +---------+-------------+ | Name | LOWER(Name) | +---------+-------------+ | Gaurav | gaurav | | Aarav | aarav | | Harshit | harshit | | Gaurav | gaurav | | Yashraj | yashraj | +---------+-------------+ 5 rows in set (0.00 sec)
更新於：04-Feb-2020
118 次瀏覽
廣告