mysql - Select command sql -

i have following columns in table:

name, company, email, contact, event-day, event-time 

i want select same times in time column of particular day each row in table via sql command.

my times area mixture of 1030, 1130, 1230. days 17th-july , 18th-july

so example i'd find out how many people have booked 1030 time slot on 17th may?

try

select * table_name event-day='17th-july' , event-time=1730 

this give desired output.