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

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