Laravel Query Builder: MySQL 'LIKE' inside a multiple where conditioned query

Question

Im trying to do a query where i have multiple conditions (including %LIKE% operator) but can't figure how to do it in Laravel's array way with query builder.

$where = ['category' => $c->id, 'name' => $c->name];
$q = Store::where($where)->get();

That way it would return an array of objects with the equal of the name, not the similar matches. Is it possible to do a %LIKE% search in that way?

Hyder B. · Accepted Answer · 2016-04-22 21:32:10Z

2

You should chain them like this:

DB::table('your-table-name')
    ->where('category','=','$c->id')
    ->where('name','=','$c->name')
    ->where('email', 'LIKE', '%test%')
    ->get();

answered Apr 22, 2016 at 21:32

Hyder B.

12.6k5 gold badges58 silver badges61 bronze badges

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

1 Comment

Zhephard Over a year ago

Somehow i read in docs it should'nt be this way, but it is, thanks

Collectives™ on Stack Overflow

Laravel Query Builder: MySQL 'LIKE' inside a multiple where conditioned query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related