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'侍蚂);