title: Using NOT LIKE in WHERE Clause
body: <p>The User Table is like below,</p>
  
  <pre><code>name  | username    | email 
  --------------------------------- 
   Joe  |    joe      | joe@mail.com      
  --------------------------------- 
   John |    ABC\john | john@abc.com      
  --------------------------------- 
   Kate |    kate     | kate@mail.com 
  --------------------------------- 
   Ron  |    ABC\ron  | ron@abc.com  
  ---------------------------------
  </code></pre>
  
  <p>The mySQL query to select all fields from the table where the username in the table doesn't start with "ABC\". Since the user logs in to an application using the active directory credentials, the user name is stored in to with Domain\Username (Eg: ABC\username). I tried to create the query but it is not working.</p>
  
  <pre><code>Select * from User where username NOT LIKE 'ABC\\\\%_'
  </code></pre>
  
  <p>But is not working.It is pulling all the user records.</p>
  
  <pre><code>name  | username    | email 
  --------------------------------- 
   Joe  |    joe      | joe@mail.com      
  --------------------------------- 
   John |    ABC\john | john@abc.com      
  --------------------------------- 
   Kate |    kate     | kate@mail.com 
  --------------------------------- 
   Ron  |    ABC\ron  | ron@abc.com  
  ---------------------------------
  </code></pre>
  
  <p>But I need users whose username doesn't starts with "ABC\". </p>
  
  <pre><code>name  | username    | email 
  --------------------------------- 
   John |    ABC\john | john@abc.com      
  --------------------------------- 
   Ron  |    ABC\ron  | ron@abc.com  
  ---------------------------------
  </code></pre>
  
  <p>I tried to filter with respect to the email address as  below it is working fine</p>
  
  <pre><code>Select * from User where email NOT LIKE '_%@abc.com' 
  </code></pre>
  
  <p>I am new to queries and can manage to write simple queries but this one I am not sure if I am following the correct way.</p>