0

More than 5 years have passed since last update.

タビアン株式会社

文字列の1文字目が母音である列を取得するクエリー

MySQL

Last updated at 2017-05-03Posted at 2017-05-03

元ネタ

方法1

IN演算子とSUBSTRING関数を使用する

SELECT DISTINCT city
FROM station
WHERE SUBSTRING(city, 1, 1) IN ("a", "e", "i", "u", "o")
;

方法2

REGEXP文字列正規表現演算子を使用する

SELECT DISTINCT city
FROM station
WHERE city REGEXP "^[aiueo]"
;

参考

12.3.2 比較関数と演算子
https://dev.mysql.com/doc/refman/5.6/ja/comparison-operators.html#function_in
12.5 文字列関数
https://dev.mysql.com/doc/refman/5.6/ja/string-functions.html
12.5.2 正規表現
https://dev.mysql.com/doc/refman/5.6/ja/regexp.html

0

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

0