title: mysql select from table where column name equals
body: <p>I have a simple table</p>
  
  <pre>
  amps | 120-240 | 120-208 | 277-480
  __________________________________
  
  10   |  $99.00  | $149.00 | $344.00
  
  20   | $199.00 | $298.00 | $688
  
  </pre>
  
  <p>I want a query something like this but I can't get it to work ...</p>
  
  <pre><code>select * from `table` where amps like '10' and column_name like '120-208';
  </code></pre>
  
  <p>or</p>
  
  <pre><code>select * from `table` where amps like '20' and column_name like '277-480';
  </code></pre>
  
  <p>Please Help!  Maybe I am overlooking an easier way to set this up?</p>
  
  <p>Thanks!</p>