Question

用ci怎么写关于between and的sql语句

Answer 1

千峰扣丁学堂IT为您解答：
select prod_name,prod_price from products where prod_price between 5 and 1;
$this->db->select('prod_name,prod_price');
$this->db->where('prod_price between 5 and 1');
$this->db->get('products');

Answer 2

--示例：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');