title: MySQL search for exact match
body: <p>I would like to search for exact match in SQL:</p>
  
  <p>In searchString column  in  user table, I have :</p>
  
  <pre><code>alan@xxx.com 654433 active other text
  ted@xsdd.com 43434 inactive other text
  </code></pre>
  
  <p>I would like to search for active or inactive only:</p>
  
  <pre><code>SELECT u FROM User u WHERE u.searchString = 'active'
  </code></pre>
  
  <p>or </p>
  
  <pre><code>SELECT u FROM User u WHERE u.searchString = 'inactive'
  </code></pre>
  
  <p>But it returns both the 2 rows for either of statements. </p>
  
  <p>Expected result: </p>
  
  <p>searchString = 'active' to return alan@xxx.com row only</p>
  
  <p>searchString = 'inactive' to return ted@xsdd.com row only</p>
  
  <p>Please help. Thanks.</p>