# 一個字段匹配多個值。取得多個匹配的數組
~~~
$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語句示例
