How to implement "where" clause with "and" condition in eloquent

Question

I've googled for minutes and couldn't find an answer to my question. I want to search users with a string that have certain characters in the name and have a specified id_admin.

I want this

 select * from users where name like '%searching name%' and id_admin = 300;

I am trying this

 $resultado = User::where("name", "like", '%'. $nome . '%')->orWhere(function ($query) {
        $query->where('id_admin', 300);
            })->get();

This is ignoring the 300

Possible duplicate of [How to create multiple where clause query using Laravel Eloquent?](https://stackoverflow.com/questions/19325312/how-to-create-multiple-where-clause-query-using-laravel-eloquent) — linktoahref, Aug 30 '18 at 12:26

score 2 · Answer 1 · answered Aug 30 '18 at 12:31

2

try this

$resultado = User::where([["name", "like", '%'. $nome . '%'],['id_admin', '300']])->get();

answered Aug 30 '18 at 12:31

Alexander Villalobos

461
3
11

score 0 · Answer 2 · answered Aug 30 '18 at 12:23

0

use:

$resultado = User::where("name", "like", '%'. $nome . '%')->where('id_admin', 300)->get();

answered Aug 30 '18 at 12:23

Jinal Somaiya

1,931
15
29

score 0 · Answer 3 · answered Aug 30 '18 at 12:24

0

It should be like this:

$resultado = User::where('id_admin', 300)->where("name", "like", '%'. $nome . '%')->get()

answered Aug 30 '18 at 12:24

narayansharma91

2,273
1
12
20

score 0 · Answer 4 · edited Aug 30 '18 at 14:23

0

$resultado = User::where([
  ['column_1', '=', 'value_1'],
  ['column_2', '<>', 'value_2'],
  [COLUMN, OPERATOR, VALUE],
  ...
])

edited Aug 30 '18 at 14:23

John Humphreys

37,047
37
155
255

answered Aug 30 '18 at 12:26

kiran kumar

11
2

How to implement "where" clause with "and" condition in eloquent

4 Answers4