title: Reorder/update sql rows by date
body: <p>Is it possible to reorder sql table rows?</p>
  
  <p>I have about 8000 rows and they are kinda in a mess as dates are out of order compared to id, I know you can reset order by deleting and re-adding id (INT auto imp) but I want to re-order by date.</p>
  
  <p>I know I could simply 'ORDER BY date' from the script but I would rather 'ORDER BY id' and have a nice clean DB ...</p>
  
  <p>I'm guessing its an UPDATE ... query and have searched high and low for an answer but have yet to find it.</p>