i have an array of dates without hour & minutes & seconds
and i want to use this array in a wherein condition with a single userId check. the problem is how can i do this with LIKE operator that my result contains all of rows that match with my dates?
this is my dates:
array:2 [ 0 => "2030-02-06" 1 => "2019-02-06" ]
an this is my query that i want to get all of result and then update them:
Point::whereIn("end_time",$dates) ->where("user_id","=",$user->user_id) ->update(['is_in_chart'=>1]);