Detailed introduction to common expression examples in ThinkPHP Where conditions

The following editor will bring you a ThinkPHP Examples of expressions commonly used in Where conditions (detailed explanation). The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor and take a look.

Where conditional expression format is:

$map['字段名'] = array('表达式', '操作条件');

where $map is an ordinary ArrayVariable can be named according to your own needs. The expression in the above format is actually the meaning of operator:

##elt<=$map['id'] = array('elt',100);id <= 100likelike$map<'username'> = array('like','Admin%');username like 'Admin%'betweenbetween and$map['id'] = array('between','1,8');id BETWEEN 1 AND 8not betweennot between and$map['id'] = array('not between','1,8' );id NOT BETWEEN 1 AND 8inin$map['id'] = array( 'in','1,5,8');id in(1,5,8)not innot in $map['id'] = array('not in','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)oror$ map['id'] = array(array('gt',3),array('lt',10), 'or');(id > 3) OR (id < 10 )xor (XOR)xorWhen only one of the two inputs is true, the result is true, otherwise it is false, example slightly. 1 xor 1 = 0expComprehensive expression$map['id'] = array(' exp','in(1,3,8)');$map['id'] = array('in','1,3,8');

ThinkPHP operator and SQL operator comparison table

TP Operator	SQL Operator	Example	ActualQueryCondition
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

Supplementary instructions

• Like SQL, ThinkPHP operators are not case-sensitive, and eq is the same as EQ.

• between and in conditions support string or array, that is, the following two writing methods are equivalent:

$map['id'] = array('not in','1,5,8');
$map['id'] = array('not in',array('1','5','8'));

exp expression

exp in the above table is not an operator, but a comprehensive expression to support more complex condition settings. The operating conditions of exp will not be treated as strings, and any syntax supported by SQL can be used, including

using functions and field names.

exp is not only used for where conditions, but also for data update, such as:

$Dao = M("Article");
//构建 save 的数据数组，文章点击数+1
$data['id'] = 10;
$data['counter'] = array('exp','counter+1');
//根据条件保存修改的数据
$User->save($data);

The above is the detailed content of Detailed introduction to common expression examples in ThinkPHP Where conditions. For more information, please follow other related articles on the PHP Chinese website!