MySQL LIKE运算符

1.SELECT 
    employeeNumber, lastName, firstName
FROM
    employees
WHERE
    firstName LIKE 'a%';
firstName 以a开头的数据

2.SELECT 
    employeeNumber, lastName, firstName
FROM
    employees
WHERE
    firstname LIKE 'T_m';firstname 以T开头 以m结尾的数据
3.

SELECT 
    productCode, productName
FROM
    products
WHERE
    productCode LIKE '%\_20%';

\转义字符 查询 中间是_20的数据
4.

SELECT 
    productCode, productName
FROM
    products
WHERE
    productCode LIKE '%$_20%' ESCAPE '$'

ESCAPE 制定特定的转义字符
结果和上面的同样!