MariaDB LOWER関数を使ってアルファベットの大文字を小文字に変換する
環境
MariaDB 10.6.4
Windows 10 Home 64bit
構文
LOWER( 文字列 )
LOWER()関数を使ってアルファベットの大文字を小文字に変換します。
使用例
SELECT LOWER( 'ARKGAME’ ),LOWER( 'Arkgame’ ),LOWER( 'a1t2C3’ );
実行結果
MariaDB [(none)]> SELECT LOWER( 'ARKGAME' ),LOWER( 'Arkgame' ),LOWER( 'a1t2C3' );
+--------------------+--------------------+-------------------+
| LOWER( 'ARKGAME' ) | LOWER( 'Arkgame' ) | LOWER( 'a1t2C3' ) |
+--------------------+--------------------+-------------------+
| arkgame | arkgame | a1t2c3 |
+--------------------+--------------------+-------------------+
1 row in set (0.076 sec)
MariaDB [(none)]> SELECT LOWER( 'ARKGAME' ),LOWER( 'Arkgame' ),LOWER( 'a1t2C3' );
+--------------------+--------------------+-------------------+
| LOWER( 'ARKGAME' ) | LOWER( 'Arkgame' ) | LOWER( 'a1t2C3' ) |
+--------------------+--------------------+-------------------+
| arkgame | arkgame | a1t2c3 |
+--------------------+--------------------+-------------------+
1 row in set (0.076 sec)
MariaDB [(none)]> SELECT LOWER( 'ARKGAME' ),LOWER( 'Arkgame' ),LOWER( 'a1t2C3' ); +--------------------+--------------------+-------------------+ | LOWER( 'ARKGAME' ) | LOWER( 'Arkgame' ) | LOWER( 'a1t2C3' ) | +--------------------+--------------------+-------------------+ | arkgame | arkgame | a1t2c3 | +--------------------+--------------------+-------------------+ 1 row in set (0.076 sec)