title: SQL query allowing a drop down list of the columns
body: <p>Is there a way to have a drop down list populate based on the values that are in the specific column that a user could then select?</p>
  
  <p>i.e.</p>
  
  <pre><code>SELECT * FROM Products
  WHERE Products.Color = //Drop down list that is populated based on the values in the column.
  </code></pre>
  
  <p>So after this would be run it would pop up a drop down list for the user to select which value they are looking for and then a table would populate based on what was selected from the list</p>
  
  <p>Is this possible?</p>
  
  <p>EDIT :</p>
  
  <p>So right now I could type </p>
  
  <p>SELECT * FROM Products
      WHERE Products.Color = &lt;&lt;>></p>
  
  <p>This would give the user a field, where they would be able to enter the color they are looking for and then a table would show with all the products that had that color.</p>
  
  <p>I'm curious if there was a way to instead have a field where they are able to select a color from the values that have already been entered into the Products.Color column?</p>