Thinkphp5运算符及SQL运算符实际查询条件说明

TP运算符    SQL运算符 例子 实际查询条件

eq =  $map['id'] = array('eq',100);  等效于：$map['id'] = 100;
neq    != $map['id'] = array('neq',100); id != 100
gt >  $map['id'] = array('gt',100);  id > 100
egt    >= $map['id'] = array('egt',100); id >= 100
lt <  $map['id'] = array('lt',100);  id < 100
elt    <= $map['id'] = array('elt',100); id <= 100
like   like   $map<'username'> = array('like','Admin%'); username like 'Admin%'
between    between and    $map['id'] = array('between','1,8');   id BETWEEN 1 AND 8
not between    not between and    $map['id'] = array('not between','1,8');   id NOT BETWEEN 1 AND 8
in in $map['id'] = array('in','1,5,8');  id in(1,5,8)
not in not in $map['id'] = array('not in','1,5,8');  id not in(1,5,8)
and（默认）and    $map['id'] = array(array('gt',1),array('lt',10));  (id > 1) AND (id < 10)
or  or $map['id'] = array(array('gt',3),array('lt',10), 'or');    (id > 3) OR (id < 10)
xor（异或）xor    两个输入中只有一个是true时，结果为true，否则为false，例子略。1 xor 1 = 0
exp    综合表达式  $map['id'] = array('exp','in(1,3,8)'); $map['id'] = array('in','1,3,8');