用ci怎么写关于between and的sql语句
答案:2 悬赏:20
解决时间 2021-02-21 22:37
- 提问者网友：相思瘸子
- 2021-02-21 16:07
用ci怎么写关于between and的sql语句
最佳答案
- 二级知识专家网友：余生继续浪
- 2021-02-21 17:16
您好，希望以下回答能帮助您
select * from table where (time 1 between '2012-02' and '2012-03') or (time 1 between '2012-06' and '2012-07')
如您还有疑问可继续追问。
select * from table where (time 1 between '2012-02' and '2012-03') or (time 1 between '2012-06' and '2012-07')
如您还有疑问可继续追问。
全部回答
- 1楼网友：无字情书
- 2021-02-21 18:13
--示例：select prod_name,prod_price from table_name where prod_price between 1 and5;
$this->db->select('prod_name,prod_price');
$this->db->where('prod_price between 5 and1');
$this->db->get('table_name');
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯