xoyip https://blog.hatena.ne.jp/xoyip/ ぴよログ https://xoyip.hatenablog.com/ Rails ActiveRecord SQLのlower Model.where("lower(name) like ?", "%john%").to_sql # SELECT \"models\".* FROM \"models\" WHERE (lower(name) like '%john%') SQLのILIKE PosgreSQLではILIKEが使える。 Model.where("name ilike ?", "%john%").to_sql # SELECT \"models\".* FROM \"models\" WHERE (name ilike '%john%') arelを使う t = Model.arel_t… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fxoyip.hatenablog.com%2Fentry%2F2014%2F05%2F24%2F190000" title="PostgresSQL+ActiveRecordのwhereで大文字小文字を無視 - ぴよログ" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> https://www.evernote.com/shard/s15/sh/7f74be95-2281-4a2f-a03a-6445baaab2fd/12d244aaf283b54c525f8f912cf2bd80/deep/0/postgresql.png Hatena Blog https://hatena.blog 2014-05-24 19:00:00 rich https://xoyip.hatenablog.com/entry/2014/05/24/190000 1.0 100%