How to use 'LIKE' in Laravel?

Question

I'm trying to use 'LIKE' in Laravel. But in the output whole data is displayed. Is my method correct? If not then correct me.

        $this->uses('Data');
        $a ='nan';
        $options = ['sort' => ['city' => 1]];
        $results = $this->Part->find([],['city','LIKE',"%$a%"],$options);
        return view('testEnv')->with('results',$results);
    }

CodeGuru · Accepted Answer · 2019-11-08T07:34:29.857

1

Query Builder

$data = DB::table('table_name')->where('col_name','LIKE','%'.$variable.'%')->get();

"%$a%" is a string ....

edited Nov 08 '19 at 07:34

answered Nov 08 '19 at 07:28

CodeGuru

3,645
14
55
99

@Ajay Kakede , i think this can be found by googling, such questions , sadly , get lots of downvote here. – CodeGuru Nov 08 '19 at 07:30
Call to undefined method MongoDB\Driver\Cursor::where() I got this error.. – Ajay Kakde Nov 08 '19 at 07:31
Try Postgres or Mysql if you're new. https://github.com/jenssegers/laravel-mongodb Refer to mongodb docs – CodeGuru Nov 08 '19 at 07:33
I tried by googling.. But it didn't worked for me.. – Ajay Kakde Nov 08 '19 at 07:33
'%'.$variable.'%' – CodeGuru Nov 08 '19 at 07:33

score 0 · Answer 2 · edited Nov 08 '19 at 07:37

0

You can use where like

$users = DB::table('users')
                ->where('name', 'like', 'T%')
                ->get();

Read documentation here

edited Nov 08 '19 at 07:37

Abhay Maurya

11,819
8
46
64

answered Nov 08 '19 at 07:28

Poldo

1,924
1
11
27

How to use 'LIKE' in Laravel?

2 Answers2