Как скорректировать такой запрос в Laravel?

Question

[dk-web]

$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();

не срабатывает

Answer 1

[Defman21]

У вас ошибка в коде.

$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();

Comments

[dk-web]

Defman21 кавычки, запятые моя вечная боль... спасибо. Правда и where не срабатывает с daysto - нужно having... просто havingBetween не нашел в доках...
$users = DB::table('users')->select(DB::raw("id,name,bday,DATEDIFF(
CONCAT(
YEAR(CURDATE()),
'-', MONTH(bday),
'-', DAY(bday)
),
CURDATE()
) AS 'daysto'"))->having('daysto', '<','10')->having('daysto', '>','0')->get();

вот так сработало. спасибо!

Answer 2

[dk-web]

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