12、MySQL的通配符数据过滤，模糊匹配

like操作符
%代表任意多个字符

mysql> select * from products where prod_name like 'jet%';
+---------+---------+--------------+------------+---------------------------------------+
| prod_id | vend_id | prod_name    | prod_price | prod_desc                             |
+---------+---------+--------------+------------+---------------------------------------+
| JP1000  |    1005 | JetPack 1000 | 35.00      | JetPack 1000, intended for single use |
| JP2000  |    1005 | JetPack 2000 | 55.00      | JetPack 2000, multi-use               |
+---------+---------+--------------+------------+---------------------------------------+
2 rows in set (0.18 sec)

_代表一个字符