title: Select multiple columns in MySQL
body: <p>I need to combine two columns into one returning table from <code>information_schema</code>.
  So, I have multiple tables with fields. In every table there are some administrative field ( like, id, lastmodify, etc.) and others ( what I need ) starting with 'F_'.</p>
  
  <pre><code>SELECT TABLE_NAME, COLUMN_NAME FROM information_schema.columns WHERE TABLE_SCHEMA = "wyro" AND COLUMN_NAME LIKE "F_%" AND TABLE_NAME LIKE "D_%"
  </code></pre>
  
  <p>Everything is fine, if there is field like 'F_%' but in case these fields are missing, the table is not in the result of the query. I tried with several way using left / right join but having it on the same table does not bring to much result.</p>
  
  <p>I need an output like:</p>
  
  <pre><code>| TABLE_NAME | COLUMN_NAME |
  | D_blabla   | F_blabla    |
  | D_blabla2  | F_blabla2   |
  | D_blabla3  |             |
  | D_blabla4  | F_blabla    |
  </code></pre>