Pattern Matching: LIKE and % : Like « Regular Expression « SQL / MySQL






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

Pattern Matching: LIKE and %

       
mysql>
mysql> CREATE TABLE sales_rep(
    ->   employee_number INT,
    ->   surname VARCHAR(40),
    ->   first_name VARCHAR(30),
    ->   commission TINYINT
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> SELECT * FROM sales_rep WHERE surname='Serote' and first_name='Mike';
Empty set (0.00 sec)

mysql>
mysql>
mysql> drop table sales_rep;
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.To reverse the sense of a pattern match, use NOT LIKE.
14.SQL patterns do not match NULL values. This is true both for LIKE and NOT LIKE
15.LIKE Search Pattern
16.Controlling Case Sensitivity in Pattern Matching. By default, LIKE is not case sensitive: