How to search an encrypted field in attr_encrypted

Viewed 2204

I have set up attr_encrypted in my app with individual 'iv's for every record.

# Fields
User.e_name
User.e_name_iv

I am trying to search the User table for a known name. I've tried:

User.find_by_name("Joe Bloggs") # undefined method "find_by_name" for Class
User.where("name = ?", "Joe Bloggs").first # column "name" does not exist
User.where(:e_name => User.encrypt_name("Joe Bloggs"))  # must specify an iv

How can I find a record by its name?

1 Answers
Related