LIKE操作符：通配符搜索只能用于文本字段(字符串)
1、%通配符
1 select
2 col_name
3 from
4 table_name
5 where
6 col_name
7 like "%str"
2、_通配符
```
1 select
2 col_name
3 from
SQL之用通配符进行过滤
1 select
2 col_name
3 from
4 table_name
5 where
6 col_name
7 like "%str"
```
1 select
2 col_name
3 from