Stuck - Showing items based on day of week

Very new to this, so forgive me if I have a bunch of follow up questions.

I’m trying to build an app that shows a list of restaurants based on their weekly specials. Ideally, a user logs in on a Sunday and it would show a list of restaurants + associated data that have specials on Sunday.

The data is entered into my database as such:

Because the week_day field is set as a text field, my sense is using “current date / time formatted as:dddd” wouldn’t work. Or at least, I couldn’t get it to work. ¯_(ツ)_/¯