ci執行sql

㈠ 用ci怎麼寫關於between and的sql語句

--示例：select prod_name,prod_price from table_name where prod_price between 1 and 5;
$this->db->並攔select('prod_name,prod_price');
$this->老蔽埋db->where('prod_price between 5 and 1');
$this->db->get('table_name'侍螞);