SQL patterns do not match NULL values. This is true both for LIKE and NOT LIKE : Like « Regular Expression « SQL / MySQL






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

SQL patterns do not match NULL values. This is true both for LIKE and NOT LIKE

      
mysql>
mysql>
mysql> SELECT NULL LIKE '%', NULL NOT LIKE '%';
+---------------+-------------------+
| NULL LIKE '%' | NULL NOT LIKE '%' |
+---------------+-------------------+
|          NULL |              NULL |
+---------------+-------------------+
1 row in set (0.00 sec)

mysql>
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.To reverse the sense of a pattern match, use 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 %