title: MySQL name LIKE '%#attributes.q#%' --- Doesn't return result for an exact match?
body: <p>I have the following MySQL query:</p>
  
  <pre><code>SELECT  *
  FROM    customer
  WHERE   
  fName LIKE '%#attributes.q#%' AND deleted = 'N'
  OR 
  lName LIKE '%#attributes.q#%' AND deleted = 'N'
  </code></pre>
  
  <p>This works fine for guesses, but if you provide an exact match: "Bill Clinton" fname=bill lname = clinton to the query above you get 0 results? where bill clint gives results.</p>
  
  <p>How can this query be updated to say find LIKE result and EQUAL TO results?</p>