内置 SQL 支持算术表达式、比较表达式。
算术表达式
格式
<field1_name> <mathematical_operator> <value>
Note:
支持复合运算,如 select ( a + 1 ) * ( a - 1 ), b + 1 from sample.employee
示例
age字段值加一
age + 1
Copy
取集合中age字段,age值加1
> db.exec( "select age + 1 from sample.employee" )
{
"age": 12
}
Copy
比较表达式
格式
<field1_name> <comparison_operator> <value | field2_name>
<field1_name> <comparison_operator> <value> <logical_operator> <field1_name> <comparison_operator> <value>
示例
-
age字段大于11
age > 11
Copy
查询匹配age大于11的记录。
> db.exec( "select * from sample.employee where age > 11" ) { "_id": { "$oid": "5aa3330fdc5673331f000000" }, "name": "Lucy", "age": 12 }
Copy
-
age字段大于等于11,且name为Harry
age >= 11 AND name = 'Harry'
Copy
查询匹配age大于等于11,且name为Harry的记录。
> db.exec( "select * from sample.employee where age >= 11 AND name = 'Harry'" ) { "_id": { "$oid": "5aa35dbedc5673331f000001" }, "name": "Harry", "age": 11 }