match_all
size
from size
match
返回指定字段
排序-sort
range
wildcard查询
合并查询语句
1. match_all
--匹配所有文档
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hNDAwZjEwN2U0MWIxZDc1LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzUzMC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
match_all
下面为查询结果
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0zYmRhYmQ4MTM1MWE3M2U2LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzgxOC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
result
size
例如如上在没有设置size的情况下默认查询出只有十条document
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1jMDY4NThjYWY0YmViNzJiLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzM1MC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
size
那么当我们需要查询出多余十条或者指定条数的数据呢,
例如如下,我们只查询出三条数据
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1jYjZmNzhmMjA1MjgyYzE4LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ2OS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
size 3
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS02OGVlY2RlN2ZlYmMzYmQ3LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzI0OS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
from size
如果我们要查找第三条到第十条的数据,可以用from size
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0xZDA0OTkyMTJkZTYxYmVkLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzIxNS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
from size
match
match用来查询某个字段是否包含需要查询的内容
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0yY2U4MjdkMzIyYjU0OWM4LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ0Ny9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hOWJkNGI0MWM1OGNhNDVkLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxMy9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
match
可以看到查询的结果的第二条为"firstname":"Burton Alice",为什么会查出此条信息呢,是因为match是知道分词器的存在的,match在查询时会报firstname中的值分为Burton 和Alice。
返回指定字段
按照上面的查询返回的时所有字段的内容,即select * from table
如果我们只需要查看firstname和age的之呢,即我们需要得到select firstname,age from table
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0yZGY3ODAzY2FmZDUzOGNlLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ4OC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hZmNlMTdjZGU0MDUwYzE5LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxMS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
_source
排序 - sort
以下是对account_number字段按照降序排序
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1lMmI0MDI2N2Y4MTY5MDFkLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ2Mi9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS01Y2Q0NDMwNmJhZTQzYWY2LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxOC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
sort
range
range from to
例如下面查找account_number 从938到948的数据(938<=account_number<=948),并且按照从大到小排序
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0xODc0MzhhNDllY2Q1MjAxLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzYwMS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1mNjZhYjgxZmQ0ZGExNjE0LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxMi9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
Range
上面查到的时938<=account_number<=948,如果需要查找938<account_number<948呢
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS00ZTY2MjBhOGIxYzVkY2Q0LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzkzNy9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
range
wildcard查询
允许使用通配符*和?来进行查询
*代表0个或多个字符
?代表任意一个字符
查找email以burton开头的document
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS04OTk3NjM1ZDQ2OTBiMTg1LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ3OS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hODcxNGI3MmU0YjQwYTY5LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQwNS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
wildcard
filter查询
filter查询的速度一般比较快
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS04YjhhMDdhMjgxYzQyYjIwLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzY4Mi9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
Filter
bool过滤查询
可以实现组合过滤查询
格式:
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1lMzQ5MzdmOTQ3MzA1MjY4LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ0MC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
bool
例如如下查询
match_all
size
from size
match
返回指定字段
排序-sort
range
wildcard查询
合并查询语句
1. match_all
--匹配所有文档
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hNDAwZjEwN2U0MWIxZDc1LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzUzMC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
match_all
下面为查询结果
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0zYmRhYmQ4MTM1MWE3M2U2LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzgxOC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
result
size
例如如上在没有设置size的情况下默认查询出只有十条document
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1jMDY4NThjYWY0YmViNzJiLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzM1MC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
size
那么当我们需要查询出多余十条或者指定条数的数据呢,
例如如下,我们只查询出三条数据
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1jYjZmNzhmMjA1MjgyYzE4LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ2OS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
size 3
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS02OGVlY2RlN2ZlYmMzYmQ3LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzI0OS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
from size
如果我们要查找第三条到第十条的数据,可以用from size
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0xZDA0OTkyMTJkZTYxYmVkLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzIxNS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
from size
match
match用来查询某个字段是否包含需要查询的内容
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0yY2U4MjdkMzIyYjU0OWM4LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ0Ny9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hOWJkNGI0MWM1OGNhNDVkLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxMy9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
match
可以看到查询的结果的第二条为"firstname":"Burton Alice",为什么会查出此条信息呢,是因为match是知道分词器的存在的,match在查询时会报firstname中的值分为Burton 和Alice。
返回指定字段
按照上面的查询返回的时所有字段的内容,即select * from table
如果我们只需要查看firstname和age的之呢,即我们需要得到select firstname,age from table
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0yZGY3ODAzY2FmZDUzOGNlLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ4OC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hZmNlMTdjZGU0MDUwYzE5LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxMS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
_source
排序 - sort
以下是对account_number字段按照降序排序
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1lMmI0MDI2N2Y4MTY5MDFkLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ2Mi9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS01Y2Q0NDMwNmJhZTQzYWY2LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxOC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
sort
range
range from to
例如下面查找account_number 从938到948的数据(938<=account_number<=948),并且按照从大到小排序
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0xODc0MzhhNDllY2Q1MjAxLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzYwMS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1mNjZhYjgxZmQ0ZGExNjE0LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxMi9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
Range
上面查到的时938<=account_number<=948,如果需要查找938<account_number<948呢
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS00ZTY2MjBhOGIxYzVkY2Q0LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzkzNy9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
range
wildcard查询
允许使用通配符*和?来进行查询
*代表0个或多个字符
?代表任意一个字符
查找email以burton开头的document
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS04OTk3NjM1ZDQ2OTBiMTg1LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ3OS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hODcxNGI3MmU0YjQwYTY5LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQwNS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
wildcard
filter查询
filter查询的速度一般比较快
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS04YjhhMDdhMjgxYzQyYjIwLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzY4Mi9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
Filter
bool过滤查询
可以实现组合过滤查询
格式:
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1lMzQ5MzdmOTQ3MzA1MjY4LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ0MC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
bool
例如如下查询
match_all
size
from size
match
返回指定字段
排序-sort
range
wildcard查询
合并查询语句
1. match_all
--匹配所有文档
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hNDAwZjEwN2U0MWIxZDc1LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzUzMC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
match_all
下面为查询结果
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0zYmRhYmQ4MTM1MWE3M2U2LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzgxOC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
result
size
例如如上在没有设置size的情况下默认查询出只有十条document
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1jMDY4NThjYWY0YmViNzJiLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzM1MC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
size
那么当我们需要查询出多余十条或者指定条数的数据呢,
例如如下,我们只查询出三条数据
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1jYjZmNzhmMjA1MjgyYzE4LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ2OS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
size 3
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS02OGVlY2RlN2ZlYmMzYmQ3LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzI0OS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
from size
如果我们要查找第三条到第十条的数据,可以用from size
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0xZDA0OTkyMTJkZTYxYmVkLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzIxNS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
from size
match
match用来查询某个字段是否包含需要查询的内容
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0yY2U4MjdkMzIyYjU0OWM4LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ0Ny9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hOWJkNGI0MWM1OGNhNDVkLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxMy9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
match
可以看到查询的结果的第二条为"firstname":"Burton Alice",为什么会查出此条信息呢,是因为match是知道分词器的存在的,match在查询时会报firstname中的值分为Burton 和Alice。
返回指定字段
按照上面的查询返回的时所有字段的内容,即select * from table
如果我们只需要查看firstname和age的之呢,即我们需要得到select firstname,age from table
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0yZGY3ODAzY2FmZDUzOGNlLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ4OC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hZmNlMTdjZGU0MDUwYzE5LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxMS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
_source
排序 - sort
以下是对account_number字段按照降序排序
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1lMmI0MDI2N2Y4MTY5MDFkLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ2Mi9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS01Y2Q0NDMwNmJhZTQzYWY2LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxOC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
sort
range
range from to
例如下面查找account_number 从938到948的数据(938<=account_number<=948),并且按照从大到小排序
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS0xODc0MzhhNDllY2Q1MjAxLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzYwMS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1mNjZhYjgxZmQ0ZGExNjE0LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQxMi9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
Range
上面查到的时938<=account_number<=948,如果需要查找938<account_number<948呢
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS00ZTY2MjBhOGIxYzVkY2Q0LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzkzNy9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
range
wildcard查询
允许使用通配符*和?来进行查询
*代表0个或多个字符
?代表任意一个字符
查找email以burton开头的document
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS04OTk3NjM1ZDQ2OTBiMTg1LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ3OS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1hODcxNGI3MmU0YjQwYTY5LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQwNS9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
wildcard
filter查询
filter查询的速度一般比较快
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS04YjhhMDdhMjgxYzQyYjIwLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzY4Mi9mb3JtYXQvd2VicA?x-oss-process=image/format,png)
Filter
bool过滤查询
可以实现组合过滤查询
格式:
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xODc1NjA4NS1lMzQ5MzdmOTQ3MzA1MjY4LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ0MC9mb3JtYXQvd2VicA?x-oss-process=image/format,png)