Query like whereIn() in array column

That's the problem with bad db design. Never also heard people storing array in db except for json. Not sure why json also but that's also a pain.

If it's in production already I think the LIKE might be the way to go, if not try refactoring out the features to another table. By doing that, you can do eloquent relationships and do something like

Property::find(1)->features()->where()->get()

Okay i understand the point, i'll try to refactor the structure.

But i don't get the find(1) in your query example. Wouldn't be like this?

Property::with('features')->where('features.name', 'pool')->get()

Thanks.

$featureType = 'pool';

$property = Property::with(['features' => function($query) use ($featureType) {
   $query->where('name', $featureType);
}])->get();

or to search on multiple values

// properties that have a pool, or air conditioner
$featureTypes = ['pool', 'air conditioner'];

$property = Property::with(['features' => function($query) use ($featureTypes) {
   $query->whereIn('name', $featureTypes);
}])->get();

See the "Constraining Eager Loads" part

https://laravel.com/docs/5.6/eloquent-relationships#eager-loading

@bufferoverflow was just an example to show you that you can do eloquent relationships like that.

@cronix pretty sure that's not what he wants. What that does is get all Properties but you are just constraining the eager loaded relationship.

What he wants is get Properties that has the specified Features. Most likely it will be a ManyMany relationship and then will do wherePivot('feature_id', 1)

What he wants is get Properties that has the specified Features.

Then it would just be a whereHas()? https://laravel.com/docs/5.6/eloquent-relationships#querying-relationship-existence

Yes that one too. Totally forgot about that one.