如何在sql中使用like和between？

Question

$query = "SELECT * FROM justshawarma_nexo_commandes where REF_CLIENT = '$uuc' 
and DATE_CREATION like '%$date3%' and DATE_CREATION like '%$date4%'";

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.

What is the error in this code?

Answer 1

   $between['date_from'] =  date("Y-m-d", strtotime($date3))." 00:00:00";
    $between['date_to'] = date("Y-m-d",strtotime($date4))." 23:59:59";


 $query = "SELECT * FROM justshawarma_nexo_commandes where REF_CLIENT = '$uuc' and DATE_CREATION BETWEEN '".$between['date_from']."' AND '".$between['date_to']."';