Creating a sql query that will show events between dates

I’m trying to create an android app that will show all events that are happening today. The problem that I have is how the database is created. If there were separate columns for start_date and end_date it would be simple but since it’s under “meta_value” I can’t figure out how to do it.

I’m also not doing this for myself so I’m unable to make any changes to wordpress. I only have access to mysql.