Rails SQL : How to search for records with a list of combination values

Question

I want to search a table for a list of pair values. Ex. This is an array of first and last names.

array = [['jane','doe'],['jack','chen'],['jane','ty'],['mike','ji'],['mike','smith']]

I want to search the User table for each one of these combinations. Currently, I can only think of running a query per combination.

array.each do |a| User.where("firstname like (?) and lastname like (?)",a[0],a[1]) end

Is there any way of running all the queries in a single query? Maintaining the combinations is required.

Salil · Accepted Answer · 2018-03-29 21:57:14Z

Following should work for you

query_string_array = [] query_array = [] array.each do |a| query_string_array << "(firstname like '%?%' AND lastname like '%?%')" query_array << a end User.where(query_string_array.join(" OR "), *query_array.flatten)

Collectives™ on Stack Overflow

Rails SQL : How to search for records with a list of combination values

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related