$players = Player::whereRaw('concat(YEAR(CURDATE()),\'-\',(MONTH(birthday)),\'-\',(DAY(birthday))) BETWEEN now() AND DATE_ADD(now(), INTERVAL 30 DAY)')->get();
may work, not for sure.
Hi, This solution works, but i want to order the result by month and day. Any idea?
Thanks
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community