Level 104
mysql (if you're using it) has a DAYNAME(date) function so you can constrain your query like this:
Member::whereRaw("DAYNAME(birthday) = 'Friday'")->get()
May 5, 2022
3
Level 1
Laravel Group Results By Days of the Week
i have a database of members with their birthdays stored as date in this format: Y-m-d. e.g 2002-01-15. i want to query the database and group the members by the days of the week from their birthdays like so: members/day-borns/friday should return all those born on friday and memers/day-borns should return all grouped by the days of the week.
any help? how do i go about it?
Level 1
@tykus it works, but i need to generate a array/collection grouped by day name also.
Level 104
@croftCoder everyone's birthday?
Member::selectRaw("*, DAYNAME(birthday) as birth_dow")
->get() // Collection
->groupBy('birth_dow');
Please or to participate in this conversation.