thinkphp一条WHERE查询的写法

Question

where [id] = array(*neq*,5); where[*age*] = array(*egt*, 20);这个变成SQL就是 where id != 5 and age >= 20;但我现在要更复杂的SQL语句： where (id != 5 and age > 20 ) or (id > 15 and age < 18 ) ;THINKPHP 应该怎写？

Answer 1

1 2 3 4 5 6

$where['id'] = array('neq','5'); $where['age'] = array('egt','20'); $map['id'] = array('gt','15'); $map['age'] = array('lt','18'); $where['_logic'] = 'OR'; $map['_complex'] = $where;