1.选择名内包含field字符串的客户

    第一种使用LIKE运算符写法
    SELECT *
    FROM customers
    WHERE last_name LIKE ‘%field%’

    第二种使用REGEXP运算符写法
    SELECT *
    FROM customers
    WHERE last_name REGEXP ‘field’

    2.选择名字以field字符串开头的客户
    SELECT *
    FROM customers
    WHERE last_name REGEXP ‘^field’

    3.选择名字以field字符串结尾的客户
    SELECT *
    FROM customers
    WHERE last_name REGEXP ‘field$’

    4.选择名字包含field字符串或者mac字符串的客户
    SELECT *
    FROM customers
    WHERE last_name REGEXP ‘field|mac’

    5.选择名字包含field字符串或者mac字符串或者rose的客户
    SELECT *
    FROM customers
    WHERE last_name REGEXP ‘field|mac|rose’

    6.选择名字以field字符串结尾或者包含mac字符串或者
    包含rose字符串的客户
    SELECT *
    FROM customers
    WHERE last_name REGEXP ‘field$|mac|rose’

    7.选择名字内包含g或者i或者m开头并且e结尾的部分
    字符串客户
    SELECT *
    FROM customers
    WHERE last_name REGEXP ‘[gim]e’

    8.选择名字内包含a-h开头并且e结尾的部分
    字符串客户
    SELECT *
    FROM customers
    WHERE last_name REGEXP ‘[a-h]e’

    总结：
    ^ begining
    $ end
    | logical or
    [ ] 里面任意匹配
    [a-z] 字符串范围

    练习：
    1.找出消费者表中客户的first_name是ELKA或者是AMBUR的情况
    SELECT *
    FROM customers
    WHERE first_name REGEXP ‘ELKA|AMBUR’

    2.找出消费者表中客户的last_name以EY或者ON结尾的情况
    SELECT *
    FROM customers
    WHERE first_name REGEXP ‘EY$|ON$’

    3.找出消费者表中客户的last_name以MY开头或者包含SE的情况
    SELECT *
    FROM customers
    WHERE first_name REGEXP ‘^MY|SE’

    4.找出消费者表中客户的last_name包含B并且跟随R或者U的情况
    SELECT *
    FROM customers
    WHERE first_name REGEXP ‘b[ru]’