将一个复合条件添加到另一个条件中查询:
$where1=array( 'Key'=>array('like','zt'.'%'), 'code'=>'02' ); $where=array( 'modes'=>1, 'Key'=>array('like','tm'.'%'), 'code'=>'02', '_complex'=>$where1, // 复合查询 '_logic'=>'or' // 关系为or ); // 查询语句 $mysql=M('Mysql')->where($where)->select();
将两个复合条件组合成另一个复合条件查询:
$where1=array(
'Key'=>array('like','zt'.'%'),
'code'=>'02'
);
$where2=array(
'modes'=>1,
'Key'=>array('like','tm'.'%'),
'code'=>'02'
);
$where=array($where1,$where2,'_logic'=>'or');
$mysql=M('Odds')->where($where)->select();