%匹配任意长度
_ 匹配单个字符
mysql> select * from table1; +----------+------------+-----+---------------------+-------+ | name_new | transactor | pid | order_date | price | +----------+------------+-----+---------------------+-------+ | 1hahha | 1xiaohong | 1 | 2019-08-04 20:45:47 | 0 | | 2hahha | 2xiaohong | 2 | 2019-08-04 20:45:57 | 0 | | 3hahha | 3xiaohong | 3 | 2019-08-04 20:46:02 | 0 | | 4hahha | 4xiaohong | 4 | 2019-08-04 20:46:05 | 0 | | 3hahha | bob | 5 | 2019-08-04 20:46:08 | 0 | | 3hahha | lee | 6 | 2019-08-04 20:46:12 | 0 | | 3hahha | lee | 7 | 2019-08-04 21:56:01 | 0 | | 3hahha | lee | 8 | 2019-08-04 21:56:10 | 0 | | 3hahha | bob | 9 | 2019-08-04 21:56:18 | 0 | | 3hahha | bob | 10 | 2019-08-04 21:56:26 | 0 | +----------+------------+-----+---------------------+-------+ 10 rows in set (0.00 sec) mysql> select * from table1 where transactor like "%xiaohong"; +----------+------------+-----+---------------------+-------+ | name_new | transactor | pid | order_date | price | +----------+------------+-----+---------------------+-------+ | 1hahha | 1xiaohong | 1 | 2019-08-04 20:45:47 | 0 | | 2hahha | 2xiaohong | 2 | 2019-08-04 20:45:57 | 0 | | 3hahha | 3xiaohong | 3 | 2019-08-04 20:46:02 | 0 | | 4hahha | 4xiaohong | 4 | 2019-08-04 20:46:05 | 0 | +----------+------------+-----+---------------------+-------+ 4 rows in set (0.00 sec) mysql> select * from table1 where transactor like "xiaohong"; Empty set (0.00 sec) mysql> select * from table1 where transactor like "%xiao"; Empty set (0.00 sec) mysql> select * from table1 where transactor like "%xiao%"; +----------+------------+-----+---------------------+-------+ | name_new | transactor | pid | order_date | price | +----------+------------+-----+---------------------+-------+ | 1hahha | 1xiaohong | 1 | 2019-08-04 20:45:47 | 0 | | 2hahha | 2xiaohong | 2 | 2019-08-04 20:45:57 | 0 | | 3hahha | 3xiaohong | 3 | 2019-08-04 20:46:02 | 0 | | 4hahha | 4xiaohong | 4 | 2019-08-04 20:46:05 | 0 | +----------+------------+-----+---------------------+-------+ 4 rows in set (0.00 sec) mysql> select * from table1 where transactor like "_xiao%"; +----------+------------+-----+---------------------+-------+ | name_new | transactor | pid | order_date | price | +----------+------------+-----+---------------------+-------+ | 1hahha | 1xiaohong | 1 | 2019-08-04 20:45:47 | 0 | | 2hahha | 2xiaohong | 2 | 2019-08-04 20:45:57 | 0 | | 3hahha | 3xiaohong | 3 | 2019-08-04 20:46:02 | 0 | | 4hahha | 4xiaohong | 4 | 2019-08-04 20:46:05 | 0 | +----------+------------+-----+---------------------+-------+ 4 rows in set (0.00 sec)