title: select from values in mysql
body: <p>What would be the MySQL way for doing a select from values?</p>
  
  <pre><code>select c from (values (1), (2), (3)) as t(c);
  </code></pre>
  
  <p>The idea is to be able to do something like this:</p>
  
  <pre><code>select * from table, (values (1), (2), (3)) as temp(c) where ...;
  </code></pre>
  
  <p>For reference, here is the Postgres doc:
  <a href="http://www.postgresql.org/docs/9.1/static/sql-values.html" rel="noreferrer">http://www.postgresql.org/docs/9.1/static/sql-values.html</a></p>