title: mysql query if else statement?
body: <p>I have this sql query:</p>
  
  <pre><code>SELECT
  S.SEARCH,
  S.STATUS,
  C.TITLE AS CategoryName,
  E.SEARCH_ENGINES AS Engine,
  S.RESULTS,
  S.DATE,
  S.TOTAL_RESULTS AS Total,
  S.ID
  
  FROM
  PLD_SEARCHES AS S
  Join PLD_CATEGORY AS C ON C.ID = S.CATEGORY_ID
  Join PLD_SEARCH_ENGINES AS E ON S.SEARCH_ENGINES_ID = E.ID
  ORDER BY S.DATE ASC
  </code></pre>
  
  <p>I want to identify if <code>S.STATUS</code> is either 1 or 0 and according to those values to return <code>COMPLETE</code> or <code>PENDING</code> in the query results</p>