title: select column names that start with x
body: <p>Im trying to select all column names from a mysql table that start with pweb and then have an integer. </p>
  
  <p>This works for all column names:</p>
  
  <pre><code>SELECT `COLUMN_NAME` 
  FROM `INFORMATION_SCHEMA`.`COLUMNS` 
  WHERE `TABLE_NAME`='producten';
  </code></pre>
  
  <p>But this does not work unfortunately, how can I make this happen?</p>
  
  <pre><code>SELECT `COLUMN_NAME` 
  FROM `INFORMATION_SCHEMA`.`COLUMNS` 
  WHERE `TABLE_NAME`='producten' AND `COLUMN_NAME` LIKE `pweb`;
  </code></pre>
  
  <p>Thanks!</p>