# 查询语言 在MyClassPHP的ORM中，内置了几种常用的查询方法 | 关键词 | SQL语言 | | --- | --- | | gt | > | | lt | < | | neq | <> | | egt | >= | | elt | <= | | eq | = | |between|between| |like|like| | in | in | |notIn| not in| |field|特殊语法exp| ## 大于 ``` $map = [ 'id' => ['gt' , 1] , ]; // 或 $map = [ 'id >' => 1 , ]; ``` ## 小于 ``` $map = [ 'id' => ['lt' , 1] , ]; // 或 $map = [ 'id <' => 1 , ]; ``` ## 不等于 ``` $map = [ 'id' => ['neq' , 1] , ]; // 或 $map = [ 'id <>' => 1 , ]; ``` ## 大于等于 ``` $map = [ 'id' => ['egt' , 1] , ]; // 或 $map = [ 'id >=' => 1 , ]; ``` ## 小于等于 ``` $map = [ 'id' => ['elt' , 1] , ]; // 或 $map = [ 'id <=' => 1 , ]; ``` ## 等于 ``` $map = [ 'id' => ['eq' , 1] , ]; // 或 $map = [ 'id' => 1 , ]; ``` ## BETWEEN、LIKE ``` // BETWEEN $map = [ 'id' => ['between' , [1 , 2 , 3 , 4 ]] , ]; // 或 $map = [ 'id between' => [1 , 2 , 3 , 4 ] , ]; // LIKE $map = [ 'id' => ['like' , 'colin'] , ]; // 或 $map = [ 'id like' => '%colin%' , ]; ``` ## IN、NOT IN ``` // IN $map = [ 'id' => ['in' , [1 , 2 , 3 , 4 ]] , ]; // 或 $map = [ 'id in' => [1 , 2 , 3 , 4 ] , ]; // NOT IN $map = [ 'id' => ['notIN' , [1 , 2 , 3 , 4 ]] , ]; // 或 $map = [ 'id notIn' => [1 , 2 , 3 , 4 ] , ]; ``` ## field ``` $map = [ 'status' => 1 , field('name is null') , ]; ```