thinkphp-where-An expression query

Grammar

Where (' field name ', ' expression ', ' query condition ');

List of expressions

An expression	meaning
EQ, =	equals (=)
NEQ, <>	Not equal to (<>)
GT, >	Greater than (>)
EGT, >=	Greater than or equal to (>=)
LT, <	Less Than (<)
ELT, <=	Less than or equal (<=)
Like	Fuzzy query
[NOT] Between	(not) Interval query
[NOT] Inch	(not) in query
[NOT] Null	Whether the query field is (not) null
[NOT] EXISTS	exists query
BX7	expression queries, supporting SQL syntax
> Time	Time comparison
< time	Time comparison
Between time	Time comparison
Notbetween time	Time comparison

Example

Where (' id ', ' eq ', ' n '); where (' id ', ' = ', +); where (' id ', 100);

Where (' id ', ' neq ', ' n '); where (' id ', ' <> ', 100);

Where (' id ', ' GT ', ' n '); where (' id ', ' > ', 100);

Where (' id ', ' egt ', ' n '); where (' id ', ' >= ', 100);

Where (' id ', ' lt ', ' n '); where (' id ', ' < ', 100);

Where (' id ', ' elt ', +); where (' id ', ' <= ', 100);

Where (' name ', ' like ', ' thinkphp% '); where (' name ', ' like ', ['%think ', ' php% '], ' OR ');

Where (' id ', ' between ', ' 1,8 '); where (' id ', ' between ', [1,8]);

Where (' id ', ' not ', ' 1,5,8 '); where (' id ', ' not ', [1,5,8]);

Where (' name ', null), where (' title ', ' null '); where (' name ', ' not null '); where (' title ', ' = ', ' null '); where (' name ', ' = ', ' Not null ');

Where (' id ', ' in ', ' 1,3,8 '); where (' id ', ' exp ', ' in (1,3,8) ');

thinkphp-where-An expression query