$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.