-- 空白の取り出し方とnullの取り出し方は異なる select * from prefectures; select * from prefectures where name is null; select * from users where name like "村%"; -- 前方一致 select * from users where name like "%郎 ...