title: How to use like and between together in sql?
body: <pre><code>$query = "SELECT * FROM justshawarma_nexo_commandes where REF_CLIENT = '$uuc' 
  and DATE_CREATION like '%$date3%' and DATE_CREATION like '%$date4%'";
  </code></pre>
  
  <p>This is my query.I want to fetch the records that match between two dates. But my date column in the table contains both date and time.That is why i want to use like and between.</p>
  
  <p>What is the error in this code?</p>