title: How do you select 2 rows from the same table in MySQL, with different conditions for each?
body: <p>i have a table I am using for referrals.  The table has 3 columns: <code>ID, FriendCode, and Referred</code>.  I want to  </p>
  
  <ul>
  <li>select <code>Referred</code> from the row where the ID = <code>currentUser</code> </li>
  <li>ID from the row where the FriendCode = <code>refereeFriendCode</code>, </li>
  <li>I want to do this with <strong>one query</strong>. </li>
  </ul>
  
  <p><code>
      ID | Referred | FriendCod
       1 |    1     |   100
       2 |    0     |   200
  </code></p>
  
  <p>I want to select 1 from referred column and 2 from ID column, and what I have is an ID of 1(current user) and FriendCode 200.</p>
  
  <p>How do I go about this?</p>
  
  <p>Thanks in advance!</p>