# 一个字段匹配多个值。取得多个匹配的数组
~~~
$sql = "select * from zt_region
where region_name like '%$province%'
or region_name like '%$city%'
or region_name like '%$district%'";
$site_row = $this->db->query($sql)->result_array();
~~~
# ci写法
```
if (!empty(trim($keyword))) {
$this->db->group_start()
->or_like('o.order_sn', $keyword)//订单编号
->or_like('oa.title', $keyword)//收货人
->or_like('oa.phone', $keyword)//手机号
->or_like('od.tracking_num', $keyword)//物流单号
->group_end();
}
```
# sql语句示例
