Rails postgresl using ILIKE with array of values

Viewed 20

How can you query multiple records using ILIKE? When passing in a single value it works but when I pass in an array of values I get an object doesn't support #inspect error

users = User.where('address ILIKE ?', ["1", "2"]) # breaks
users = User.where('address ILIKE ?', "2")        # works

error: User Load (6.6ms)  SELECT "users".* FROM "users" WHERE (lower(address)='1','2')                                                                      
(Object doesn't support #inspect)  
0 Answers
Related