title: MySQL SELECT rows with string but not other strings doesn't work as expected
body: <p>I have text data in a column in a table in MySQL. I am trying to select only those rows that have:</p>
  
  <pre><code>SELECT * FROM `leganalyse_unitsub` WHERE `content` LIKE '%Act%' AND `content` NOT LIKE '%this Act%' AND `content` NOT LIKE '%Act (%' AND `content` NOT LIKE '%[Act%'
  </code></pre>
  
  <p>I am trying to get <em>only</em> those rows that have the string "Act" in it, but these rows should also not have the strings:
  "this Act", "Act (", "[Act".</p>
  
  <p>However, after executing query, I get rows like:
  "(11)  Where the Registrar discloses and makes available for public inspection the particulars of a public accountant’s residential address, the Registrar must give notice of that fact to the public accountant."
  Which do not even have the word "Act" at all.</p>
  
  <p>Why, and how do I modify the query to get what I want?</p>