title: how to search month with year in mysql
body: <p>I have a table. It has a varchar type date column.<br>
  I want to search that table using date, but i want to search only from month with year.</p>
  
  <p><strong>example:</strong> <code>12-2016</code><br>
  How can I write the query for that?<br>
  I want that part to assign to a variable of jasper  </p>
  
  <p>**example:**WHERE  .............  =$P{invDate}</p>
  
  <p><strong>example as in my jasper report:</strong>  </p>
  
  <p>SELECT invoiceheader.inNo AS invoiceheader_inNo, invoiceheader.cusID AS invoiceheader_cusID, invoiceheader.soNo AS invoiceheader_soNo, invoiceheader.total AS invoiceheader_total, invoiceheader.dis AS invoiceheader_dis, invoiceheader.netTotal AS invoiceheader_netTotal, invoiceheader.cash AS invoiceheader_cash, invoiceheader.bal AS invoiceheader_bal, invoiceheader.date AS invoiceheader_date FROM invoiceheader invoiceheader WHERE ...........................................=$P{invDate} </p>
  
  <p><strong>I need a perfect query for the above space</strong></p>