thinkphp operator and SQL operator comparison table

thinkphp operator and SQL operator comparison table

TP operator	SQL operator	Example	actual query conditions
eq	=	$map [' id '] = array (' eq ', 100);	Equivalent to: $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
Inch	Inch	$map [' id '] = array (' In ', ' 1,5,8 ');	ID in (1,5,8)
Not in	Not in	$map [' id '] = array (' Not ', ' 1,5,8 ');	ID not in (1,5,8)
and (default)	and	$map [' id '] = Array (array (' GT ', 1), Array (' LT ', 10));	(ID > 1) and (ID < 10)
Or	Or	$map [' id '] = array (' GT ', 3), array (' LT ', ten), ' or ');	(ID > 3) OR (ID < 10)
XOR (different OR)	Xor	Only one of the two inputs is true, the result is true, otherwise false, the example is slightly.	1 XOR 1 = 0
Exp	Synthetic expressions	$map [' id '] = Array (' exp ', ' in (1,3,8) ');	$map [' id '] = array (' In ', ' 1,3,8 ');

Thinkphp using an expression in a Where condition

Source: http://www.cnblogs.com/martin1009/archive/2012/08/24/2653718.html

thinkphp operator and SQL operator comparison table