To reverse the sense of a pattern match, use NOT LIKE. : Like « Regular Expression « SQL / MySQL






  1. SQL / MySQL
  2. Regular Expression
  3. Like

To reverse the sense of a pattern match, use NOT LIKE.

      
mysql>
mysql> CREATE TABLE mytable
    -> (
    ->  name    VARCHAR(20)
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO mytable (name)
    ->  VALUES
    ->          ('copper'),
    ->          ('gold'),
    ->          ('iron'),
    ->          ('lead'),
    ->          ('mercury'),
    ->          ('platinum'),
    ->          ('silver'),
    ->          ('tin')
    -> ;
Query OK, 8 rows affected (0.00 sec)
Records: 8  Duplicates: 0  Warnings: 0

mysql>
mysql> SELECT * FROM mytable;
+----------+
| name     |
+----------+
| copper   |
| gold     |
| iron     |
| lead     |
| mercury  |
| platinum |
| silver   |
| tin      |
+----------+
8 rows in set (0.00 sec)

mysql>
mysql>
mysql> SELECT name FROM mytable WHERE name NOT LIKE '%i%';
+---------+
| name    |
+---------+
| copper  |
| gold    |
| lead    |
| mercury |
+---------+
4 rows in set (0.00 sec)

mysql>
mysql> drop table mytable;
Query OK, 0 rows affected (0.00 sec)

mysql>








Related examples in the same category

1.Where clause: like and %
2.To get the equivalent with LIKE, you'd have had to use % wildcards at the end:
3.like B%
4.like %r
5.LIKE '%e_'
6.Like and concat
7.Like and escape
8.LIKE '%is%'
9.LIKE '______' (underscore)
10.LIKE '______%' (underscore and %)
11.LIKE '_r%r_'
12.LIKE '_@%%@%_' ESCAPE '@'
13.SQL patterns do not match NULL values. This is true both for LIKE and NOT LIKE
14.LIKE Search Pattern
15.Controlling Case Sensitivity in Pattern Matching. By default, LIKE is not case sensitive:
16.Pattern Matching: LIKE and %