title: Select from array in MySQL
body: <p>Is it possible in MySQL to select from a static set of integers? Given an array of integers like 1 and 2, what is the correct syntax in MySQL to do something like:</p>
  
  <pre><code>select 
      * 
  from 
      (values(1),(2)) 
  </code></pre>
  
  <p>Which should return one row containing the number 1 and one row containing the number 2.</p>
  
  <p>In other SQL than MySQL (e.g. MSSQL) this is possible. Is there a way to do this in MySQL?</p>