title: mysql SELECT 0 or 1 when LIKE is found
body: <p>I'm looking for a way to return a 0/1 when a LIKE is found.
  I had it working with a CASE IF statement on a different query which uses a MATCH AGAINST. But I can't seem to get this working.
  for example: this worked in the SELECT part of the query.</p>
  
  <pre><code>SELECT *, (CASE WHEN IF((MATCH (name) AGAINST ("rubert"  IN BOOLEAN MODE))&gt;=1, 1, 0) = 1 THEN 1 ELSE 0 END) as r2....
  </code></pre>
  
  <p>But i'm looking for a 0 or a 1 against a LIKE.</p>
  
  <p>eq. </p>
  
  <pre><code>SELECT *, (CASE WHEN IF (name LIKE "%rubert%") == FOUND) THEN 1 ELSE 0 END) as found FROM....
  </code></pre>
  
  <p>Have a feeling i'm really close, but seem not to get it exactly...</p>