title: Search date in database PHP
body: <p>When I was a start up student in PHP I made my database to store dates the date and time together, now I have a big problem, I have already in the database over 3000 orders but when I want to make a search with dates am I in big trouble because the dates and time is together in one field, I tried to make the query like <code>where date LIKE '%$date'</code> but I'm getting no results, has anybody any idea what I can do now?</p>
  
  <p>And also how can I change the whole database it should be all dates and time separately and it should not effect my database?</p>
  
  <p>UPDATE:</p>
  
  <p>The data in the database looks like, <code>10/16/2012 5:00pm</code></p>
  
  <p>Appreciate any help.</p>