Do rails exist? Case insensitive

Question

Model.exists?("lower(email) = ?", params[:email].downcase)

Returns an error: ArgumentError (wrong number of arguments (2 for 0..1)):

Is it possible to do exists?

with a case insensitive match?

+3

Philip May 14 '15 at 15:38

2 answers

You can also do the following:

Model.where("lower(email) = ?",params[:email].downcase).exists?

+8

pangpang May 14 '15 at 15:46

MCBama · Accepted Answer · 2015-05-14T15:43:53+0000

All you have to do is the following:

Model.exists?(["lower(email) = ?", params[:email].downcase])

It looks for one argument, but you provide two. Using an array form and a find-style conditional should get what you need.