title: How can I reorder rows in sql database
body: <p>Is it possible to reorder rows in SQL database?
  For example; how can I swap the order of 2nd row and 3rd row's values?</p>
  
  <p>The order of the row is important to me since i need to display the value according to the order.</p>
  
  <hr>
  
  <p>Thanks for all the answers. But 'Order by' won't work for me.</p>
  
  <p>For example, I put a list of bookmarks in database. 
  I want to display based on the result I get from query.  (not in alphabet order). Just when they are inserted.  </p>
  
  <p>But user may re-arrange the position of the bookmark (in any way he/she wants).  So I can't use 'order by'.</p>
  
  <p>An example is how the bookmark display in the bookmark in firefox. User can switch position easily.  How can I mention that in DB?</p>
  
  <p>Thank you.</p>