title: MySql return 'I FOUND IT' string if found in table
body: <p>I am making a small MySQL query, I am a little stumped on how to form it.</p>
  
  <p>I am just trying to return a string that is NOT in the database if a result is found in the database.</p>
  
  <p>an example being:</p>
  
  <pre><code>{-----table-----}
  |(id)    (Value)|
  |1        Bob   |
  |2        Jason |
  |3        Alex  |
  |4        Tony  |
  {---------------}
  </code></pre>
  
  <p>The query would work something like</p>
  
  <pre><code>SELECT IF((SELECT Value FROM table WHERE (Value = 'Jason')),'I FOUND HIM','HE IS MISSING!')
  </code></pre>
  
  <p>The output would then be 'I FOUND HIM'</p>
  
  <pre><code>SELECT IF((SELECT Value FROM table WHERE (Value = 'Jerry')),'I FOUND HIM','HE IS MISSING!')
  </code></pre>
  
  <p>The output would then be 'HE IS MISSING!'</p>