How to use whereBetween and like operator together in laravel?

Question

I need to change the below MySQL code to laravel format using where, between and like operators together:

select count(id) from tbl1 
where created_at BETWEEN 
   '2018-12-10%' AND '2018-12-12%'

Why do you want to treat dates as strings? Simple [SARGable](https://stackoverflow.com/a/799616/5070879) expression `created_at >= '2018-12-10' AND created_at < '2018-12-13'` Effective range: *`2018-12-10 00:00:00 - 2018-12-12 23:59:59`* — Lukasz Szozda, Jan 13 '19 at 12:10
`DB::table('test')->whereBetween('created_at',[$sdate.'%', $enddate.'%'])->count();` — Zaker Husien Yusofi, Jan 13 '19 at 12:18
thank you Lukasz Szozda , I got the answer the above query works fine. — Zaker Husien Yusofi, Jan 13 '19 at 12:19

score 2 · Accepted Answer · answered Jan 13 '19 at 12:21

2

I found the answer as below:

\DB::table('tbl1')->whereBetween('created_at',[$sdate.'%', $enddate.'%'])->count();

answered Jan 13 '19 at 12:21

Zaker Husien Yusofi

307
3
18

score 0 · Answer 2 · answered Jan 30 '20 at 15:12

0

If you're using a Model you could use the whereBetween method, take a look at the following example: User::query()->whereBetween('created_at', [$start, $end])->count();

answered Jan 30 '20 at 15:12

Jelmer de Vries

92
1
7

How to use whereBetween and like operator together in laravel?

2 Answers2