How to correct such request in Laravel?

Question

Laravel

$users = DB::table('users')->select(DB::raw('id,name,bday,DATEDIFF(
                 CONCAT(
                 YEAR(CURDATE()),
                 '-', MONTH(bday),
                 '-', DAY(bday)
                 ),
             CURDATE()
             ) AS daysto'))->whereBetween('daysto', [-10, 10])->get();

does not work

Answer 1

You have an error in your code.

$users = DB::table('users')->select(DB::raw("id,name,bday,DATEDIFF(
                 CONCAT(
                 YEAR(CURDATE()),
                 '-', MONTH(bday),
                 '-', DAY(bday)
                 ),
             CURDATE()
             ) AS daysto"))->whereBetween('daysto', [-10, 10])->get();