title: How can I display results from SQL query as custom values?
body: <p>I have a real simple question I was hoping to get help with.</p>
  
  <p>Here is my query:</p>
  
  <pre><code>SELECT
  prescription.PRE_ID AS `Prescription ID`,
  
  redeemed_prescriptions.PRE_ID AS `Redeemed`
  
  FROM prescription
  LEFT JOIN redeemed_prescriptions ON prescription.PRE_ID = redeemed_prescriptions.PRE_ID;
  </code></pre>
  
  <p>And here is the result:</p>
  
  <pre><code>Prescription ID | Redeemed
  ---------------------------
  1               | 1
  2               | NULL
  3               | 3
  4               | NULL
  5               | NULL
  </code></pre>
  
  <p>As you can see,  when there is a match (i.e. the prescription has been redeemed) the matching number appears in the row, otherwise NULL.</p>
  
  <p>My question is how can I make it so that when there is a match it displays 'True' and when there isn't a match it displays 'False' in the query output.</p>
  
  <p>Thanks in advance for any help or advice I can get on this.</p>