title: SQL - how to get specific value of cell?
body: <p>Fist time using SQL and already confused.
  I have a table :</p>
  
  <pre><code>A  |  B
  --------
  a  | 6
  b  | 10
  c  | 12
  </code></pre>
  
  <p>I want to filter it by using string comparison, but getting the value of the second column :</p>
  
  <pre><code>myNum = SELECT B WHERE A ='a'
  </code></pre>
  
  <p>At the end I want the value of myNum to be 6. </p>
  
  <p>Just can't get it right... any help would be very appreciated!</p>