title: I DISTINCTly hate MySQL (help building a query)
body: <p>This is staight forward I believe:</p>
  
  <p>I have a table with 30,000 rows. When I <code>SELECT DISTINCT 'location' FROM myTable</code> it returns 21,000 rows, about what I'd expect, but it only returns that one column.</p>
  
  <p>What I want is to move those to a new table, but the whole row for each match. </p>
  
  <p>My best guess is something like <code>SELECT * from (SELECT DISTINCT 'location' FROM myTable)</code> or something like that, but it says I have a vague syntax error.</p>
  
  <p>Is there a good way to grab the rest of each DISTINCT row and move it to a new table all in one go?</p>