title: MySql SELECT names from users WHERE name LIKE "$searchTerm" AND status <> 'blocked'
body: <p>I need to make a Query like this.</p>
  
  <pre><code>MySql-&gt; SELECT names from users_tb WHERE names LIKE "$searchTerm" AND status &lt;&gt; 'blocked'
  </code></pre>
  
  <p>So The Query should SELECT all ROWS with names that match the "Search term", but Skip ROWS where <code>"status='blocked'"</code>. Now the issue is that Once the <strong>Like '%$searchTerm%'</strong> is called, the Query returns even those users that are <strong>'blocked'</strong>. In other words, the <strong>AND</strong>  is completely ignored. </p>
  
  <p>How could this be properly done?</p>
  
  <p>Any Help is highly appreciated.</p>