title: In my query MYSQL CAST not working
body: <p>I don't know what is wrong in my MYSQL query:</p>
  
  <pre><code>SELECT * FROM package_customers pc 
  left join installations ins on ins.package_customer_id = pc.id 
  WHERE pc.status = 'scheduled' 
  AND CAST(ins.schedule_date as DATE) &gt;='10-27-2017'
  </code></pre>
  
  <p>The fields are:</p>
  
  <ol>
  <li><p>status data type enum</p></li>
  <li><p>schedule_date data type varchar</p></li>
  </ol>
  
  <p>In the column <code>schedule_date</code>, the  data is like this: <code>10-27-2017 12AM  12PM</code></p>
  
  <p>I am trying to find date-wise data.</p>