title: Laravel : Order by string date using query builder with MySql
body: <p>The table have a startDate column which is <code>VARCHAR</code> type, so need to get rows by ascending order using this column.</p>
  
  <p>Tried this :</p>
  
  <p><code>orderBy(DB::raw("DATE(startDate)"), 'ASC')</code> </p>
  
  <p>the above does not return correct order, how to pass string date in order by clouse?</p>
  
  <p>Example:</p>
  
  <p><code>'startDate' =&gt; '07-Nov-2017'</code></p>
  
  <p><code>$items = DB::table("mytable")-&gt;orderBy(DB::raw("DATE(startDate)"), 'ASC')-&gt;where('userId','=',$userId)-&gt;get();</code></p>