「MariaDB 10.6.4」UPPER関数でアルファベットの小文字を大文字に変更する
環境
windows 10 64bit
MariaDB 10.6.4
書式
UPPER(文字列)
UPPER関数を使用して、アルファベットの小文字を大文字に変更します。
使用例
MariaDB [(none)]> SELECT UPPER('study') resA,UPPER('Atu') resB,UPPER('Study123') resC,UPPER('テストmessage') resD;
+-------+------+----------+------+
| resA | resB | resC | resD |
+-------+------+----------+------+
| STUDY | ATU | STUDY123 | |
+-------+------+----------+------+
1 row in set (0.183 sec)
MariaDB [(none)]> SELECT UPPER('study') resA,UPPER('Atu') resB,UPPER('Study123') resC,UPPER('テストmessage') resD;
+-------+------+----------+------+
| resA | resB | resC | resD |
+-------+------+----------+------+
| STUDY | ATU | STUDY123 | |
+-------+------+----------+------+
1 row in set (0.183 sec)
MariaDB [(none)]> SELECT UPPER('study') resA,UPPER('Atu') resB,UPPER('Study123') resC,UPPER('テストmessage') resD;
+-------+------+----------+------+
| resA | resB | resC | resD |
+-------+------+----------+------+
| STUDY | ATU | STUDY123 | |
+-------+------+----------+------+
1 row in set (0.183 sec)