Rails: finding records where attribute includes some value

Question

I have a "Stores" model that contains various locations. Among the attributes for each store is the the "brands" that is carries.

Example: Store1, brands: "Nike, Adidas, Polo"; Store2, brands: "Jcrew, Polo"

I want to be able to select all stores where brand contains "Adidas" (may also contain other brands)

Something along the lines of:

@search = Stores.where(brands: params[:brand])

but need it to be

@search = Stores.where(brands.include? params[:brand])

which clearly doesn't work

What's the best way to deal with this?

Part of the problem may be that this is not the best way to track brands. Brands should be normalized into their own table with an associated join table. Proper architecture would obviate this entire question. — Brad Werth, Jun 25 '14 at 23:01

infused · Accepted Answer · 2014-06-25T23:12:57.517

2

If brands is a string and params[:brand] contains a single brand name, you can use MySQL's LIKE function:

@search = Stores.where(['BRANDS LIKE ?', "%#{params[:brand]}%"])

edited Jun 25 '14 at 23:12

answered Jun 25 '14 at 22:49

infused

score -3 · Answer 2 · answered Jun 25 '14 at 22:56

-3

You can do this with the following statement.

@search = Stores.where("brands = ?", params[:brand])

A similar example is given in Listing 11.43 of the Hardtl rails tutorial

You should also note that rails models generally are meant to have singular names, i.e. Store instead of Stores.

answered Jun 25 '14 at 22:56

quilligana

This does exactly the same as `where(brands: params[:brand])` – Eyeslandic Jun 25 '14 at 22:58

2 Answers2