title: Is there a way to use DATE_FORMAT to SELECT multiple months?
body: <p><a href="https://i.stack.imgur.com/mFw1L.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mFw1L.png" alt="enter image description here"></a>
  From the above ERD I am trying to Select the total number of products sold and their descriptions in February, September, and December.</p>
  
  <p>Here's a snippet of my invoice table:</p>
  
  <pre><code>INV_NUMBER CUS_CODE INV_DATE 
  
  1001       10014    2016-01-16 00:00:00
  1002       10011    2016-01-16 00:00:00
  1003       10012    2016-01-16 00:00:00
  </code></pre>
  
  <p>My SQL query :</p>
  
  <pre><code>SELECT P_DESCRIPT AS Product, SUM(P_CODE) AS 'Units Sold'
  
  FROM  product
  JOIN invoice 
  WHERE INV_DATE LIKE (DATE_FORMAT("2017-01%-15", "%Y", "%m" ) 
  OR  DATE_FORMAT("2017-06%-15", "%Y", "%m" ) 
  OR DATE_FORMAT("2017-07%-15", "%Y", "%m" ))
  
  GROUP BY P_DESCRIPT;
  </code></pre>
  
  <p>I know that I got everything wrong from "WHERE ... %m" ))
  I need to get something like this <a href="https://i.stack.imgur.com/6zr2c.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6zr2c.png" alt="enter image description here"></a></p>