数据结构
网络
关系数据库管理系统
操作系统
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 次浏览
广告