title: Can we use "NOT LIKE " in sql
body: <p>Can we use <code>"NOT LIKE '%abc%'"</code>  just opposite of <code>LIKE '%abc%'</code> ?
  i tried and got some result but dont look like correct!!</p>
  
  <p>Is there anything similar to <code>regex in SQL</code>.</p>
  
  <p>Eg:</p>
  
  <p>i hae a table with 3 field.</p>
  
  <pre><code>id  name  address
  1    xyz    1234 abcd 
  2    abc    nomans land
  3    omg    #123 new-york
  3    nom    $123 &amp;7up
  </code></pre>
  
  <p>can i fetch the address <strong>**with special characters with out checking each special</strong> character one by one . How </p>