Where like query builder in Laravel with MongoDb

Question

I'm trying to make a where ... like in Laravel with MongoDb for my search bar. In mysql I created with:

DB::table('Account')->where('avail_balance','like','%' .$searchValue . '%');

But with MongoDb Jenssegers, I can't use it. It's return nothing.
After search some post in here, I use:

$account = DB::connection('mongodb')->collection('Account')->where('avail_balance',"%{$searchValue}%")->paginate(5);

It's still return nothing.
How I should convert this query from mysql to mongodb?
Thank you very much!

Inzamam Idrees · Accepted Answer · 2019-04-01 05:08:23Z

3

Try this with the end of get() method:

DB::table('Account')->where('avail_balance','LIKE','%'.$searchValue.'%')->get();

And try this using LIKE query:

$account = DB::connection('mongodb')->collection('Account')->where('avail_balance','LIKE','%'.$searchValue.'%')->paginate(5);

I hope it would helpful.

answered Apr 1, 2019 at 5:08

Inzamam Idrees

1,98717 silver badges28 bronze badges

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

1 Answer 1