How to convert sql command to laravel eloquent

Question

Here is my code using mysql command

SELECT * FROM `order_list` WHERE currentdate like '%12%' and currentdate like '%2017%'

but Im having a problem converting it into laravel eloquent.

$orderlists = Orderlist::where('currentdate', 'like', "%$month%")
                                    ->where('currentdate', 'like', "%$year%")
                                    ->get();

is this correct?thanks

It's bad idea to search dates with LIKE. mysql has YEAR() or MONTH() function which fit better. — u_mulder
– u_mulder, Commented Nov 28, 2017 at 9:09
That could potentially return the 12th January 2017 (12/01/2017), something to think about. — MCMXCII
– MCMXCII, Commented Nov 28, 2017 at 9:10
In currentdate like '%12%' you search what? 12 as a day, or 12 as a month (december). — u_mulder
– u_mulder, Commented Nov 28, 2017 at 9:12
Please, make an effort and use a search engine. You will find plenty of answers. — u_mulder
– u_mulder, Commented Nov 28, 2017 at 9:13
So why are you using a varchar to store dates when you should be using a date datatype? This is going to cause you a lot of problems in the future — Mark Baker
– Mark Baker, Commented Nov 28, 2017 at 9:19

Tino · Accepted Answer · 2017-11-28 09:26:25Z

1

$orderlists = Orderlist::whereMonth('currentdate', 'LIKE','%'.$month.'%')
                                ->whereYear('currentdate', 'LIKE', '%'.$year.'%')
                                ->get();

answered Nov 28, 2017 at 9:26

Tino

226 bronze badges

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

Comments

Bhupendra Mistry · Accepted Answer · 2017-11-28 09:20:11Z

0

You can also use your raw sql query as shown below

$orderlists = DB::select("SELECT * FROM `order_list` WHERE currentdate like '%12%' and currentdate like '%2017%'");

answered Nov 28, 2017 at 9:20

Bhupendra Mistry

6284 silver badges12 bronze badges

Collectives™ on Stack Overflow

How to convert sql command to laravel eloquent

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related