Date in string format show two records in advance <p>My query is working fine but I wish to show counts of today's date + add 2 more days in advance and order data by today's date followed by tomorrow and day after?</p> <p>since there are already too many records so the <strong>varchar</strong> row <code>meeting_date</code> cannot be changed in another format</p> <p>Here is MySQL query </p> <p>date is stored as month/date/year as in 11/01/2016.</p> <pre><code>$today = date("m/d/Y"); $query = "SELECT COUNT(*) as num FROM records WHERE meeting = 'Yes' AND (meeting_date LIKE '%".$today."%') ORDER BY id DESC"; $total_pages = mysql_fetch_array(mysql_query($query)); </code></pre> <p>Appreciate your time and help.</p>