title: Creating a linked list or similar queue in MySQL?
body: <p>I have a table of items that need to be displayed in a certain order, but that order can be changed.  Items can be added at the beginning, end, or in the middle, and items can be rearranged.  How can I set up the table to keep track of that order in such a way that it's easy to modify but the list can also be fetched in order with a single query?</p>
  
  <p>For example, I could have a "NEXT_ID" column to do it linked list-style, but then how would I run a SELECT query to get the rows in order of the NEXT_ID chain?</p>
  
  <p>Apologies in advance for the super-obvious solution I'm probably missing.</p>