tp的复合查询

来源:互联网 发布:unity3d 点光源不亮 编辑:程序博客网 时间:2024/05/02 00:26
    $where1=array(    'b'=>$keywords,    'c'=>$keywords,    '_logic'=>'and' );$where=array(    'a'=>$keywords,    '_complex'=>$where1,    '_logic'=>'or' );M('X')->where($where)->select();实现效果如下----
     SELECT * FROM TABLE WHERE a=$keywords or(b=$keywords and c=$keywords)

    from: http://www.thinkphp.cn/topic/21771.html