Question

thinkphp一条WHERE查询的写法

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

$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;

试试

望采纳 Thx

Answer 2

用 $map['_complex']
例如：
$where['name'] = array('like','%thinkphp%');
$where['title'] = array('like','%thinkphp%');
$where['_logic'] = 'or';
$map['_complex'] = $where;
$map['id'] = array('gt',1);
查询条件是
( id > 1) AND ( ( name like '%thinkphp%') OR ( title like '%thinkphp%') )