title: SQL wildcard matching excluding a specific pattern
body: <p>sorry about the question I am a newbie to sql. i am attempting to create a search query for our database and I was wondering how would you filter certain words from your query for example:</p>
  
  <p>Here is the sample data (the name column): Jean, Jain, Joan, Jorn, Juan, John, Juin</p>
  
  <p>Lets say that we are searching for the names that start with "J" and end with "n" but we don't want to include "John".</p>
  
  <pre><code>SELECT id, name
  FROM tblusers
  WHERE name LIKE 'j__n'
  WHERE name NOT LIKE 'John'
  </code></pre>
  
  <p>Obviously the above will have an error, so I was wondering how do I correctly write the above. </p>
  
  <p>Thanks in advance.</p>