mysql查询在某些日子里查找商店名称

Question

I need a mysql query to find shopname open in certain days,

My Shop_availability table saving shop_name & openday .

Table like this.

  shop_name  openday 
------------------------
    shop-A      Monday  
    shop-A      Tuesday
    shop-A      Wednesday
    shop-A      Thursday
    shop-A      Friday
    shop-B      Monday 
    shop-B      Tuesday

I want to get shop_name which open in Monday,Friday

Select * availability  WHERE openday IN('Monday','Friday')

above query not working,

Please help me , Thanks,

Answer 1

Close, but you want aggregation:

SELECT a.shop_name
FROM availability a
WHERE a.openday IN ('Monday', 'Friday')
GROUP BY a.shop_name
HAVING COUNT(*) = 2;

The HAVING clause is used to verify that there are two matches on the days (the number of days you are looking for). Presumably, there are no duplicates in your original data.