if( $data['from'] && $data['to'] ){
if( $data['l_type'] == 0 ){
$where['g_odds'] = [ 'between', $data['from'].','.$data['to'] ];
}elseif( $data['l_type'] == 1 ){
}elseif( $data['l_type'] == 2 ){
}
}
上面的between那样的写法最终生成的SQL语句是:string(209) "SELECT `g_id`,`g_nid`,`g_date`,`g_mingxi_2`,`g_jiner`,`g_odds`,`g_w`,`g_ts` FROM `g_zhudan` WHERE `g_odds` IN (0,99) AND `g_id` = 1 ORDER BY `g_date` DESC LIMIT 1"
为什么变成 IN 了?求解? 最佳答案
