title: How to properly get all the data base on date column current date using mysql
body: <p>I have problem i don't think if this is a bug, why I can't get all the data base on the current date. I have here on my table column order_date where the customer order on the day. However I can't get the data based on my script, but <strong>on my script I did is DATE(order_date)=CURDATE()</strong></p>
  
  <p><strong>This is the order_date of customer today:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/hD9Fx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hD9Fx.png" alt="customer_order_date"></a></p>
  
  <p><strong>This is the script that I have:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/ngz1t.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ngz1t.png" alt="script"></a></p>
  
  <pre><code>    SELECT op.order_id,op.customer_id,customer_name,customer_number,op.or_number,delivery_status,
  order_ship_address,delivery_status,order_date,amount,driver_firstname,transaction_number 
  FROM order_properties as op 
  LEFT JOIN (SELECT customer_id,order_id,amount,subtotal FROM payment) p 
  ON op.order_id = p.order_id 
  LEFT JOIN (SELECT customer_id,customer_name,customer_location,customer_number FROM customer_details) 
  cd ON op.customer_id = cd.customer_id LEFT JOIN (SELECT driver_id,driver_firstname FROM driver) drive 
  ON op.driver_id = drive.driver_id WHERE  DATE(order_date)=CURDATE()
  </code></pre>
  
  <p>As you see guys, there is no data that I get, but the order_date is today.</p>
  
  <p><strong>Reference:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/Y7RbD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y7RbD.png" alt="Order Date"></a></p>