Check if string contains element in Array

Question

I'm using Rails and learning ActiveRecord and I came across a vexing problem. Here's an array in my model:

@sea_countries = ['Singapore','Malaysia','Indonesia', 'Vietnam', 'Philippines', 'Thailand']

And here's my ActiveRecord object:

@sea_funding = StartupFunding.joins(:startup)
                             .where('startups.locations LIKE ?', '%Singapore%')

What I'm trying to do is to return a result where a string in the 'locations' column matches any element in the Array. I'm able to match the strings to each element of an Array (as above), but I'm not sure how to iterate over the whole Array such that the element is included as long as there's one match.

The intent is that an element with multiple locations 'Singapore,Malaysia' would be included within @sea_funding as well.

Well, don't ask me why 'locations' is set as a string. It's just the way the previous developer did it.

franksort · Accepted Answer · 2014-02-21 03:19:51Z

1

You use an IN clause in your .where filter:

@sea_funding = StartupFunding.joins(:startup)
                             .where(["startups.locations IN (?)", @sea_countries])

edited Feb 21, 2014 at 3:19

answered Feb 21, 2014 at 3:09

franksort

3,1532 gold badges21 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alexander · Accepted Answer · 2014-02-21 03:09:32Z

0

@sea_countries.include?(startups.locations)

This will return a boolean TRUE if the value of the locations column in startups can be found in the sea_countries array, false if it is absent.

answered Feb 21, 2014 at 3:09

Alexander

6321 gold badge9 silver badges20 bronze badges

Comments

lalameat · Accepted Answer · 2014-02-21 03:23:20Z

0

Could this work for you?

first = true
where_clause = nil

sea_countries.each do |country|
  quoted_country = ActiveRecord::Base.connection.quote_string(country)
  if first
     where_clause = "startups.locations LIKE '%#{quoted_country}%' "
     first = false
  else
     where_clause += "OR startups.locations LIKE '%#{quoted_country}%' "
  end
end

@sea_funding = StartupFunding.joins(:startup)
                             .where(where_clause)

answered Feb 21, 2014 at 3:23

lalameat

7544 silver badges10 bronze badges

Collectives™ on Stack Overflow

Check if string contains element in Array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related