select * from index_person where name = 'jeck' or sex = 'male' order by age,sex
{
"query":{
"bool":{
"should":{
{"match":{"name": "jeck"}},
{"match": {"sex": "male"}},
}
}
},
"sort":[{"age":{"order":"asc"},
{"sex":{"order":"desc"}}]
}
like查询 wildcard
select * from index_person where name like '%jeck%'
{
"query":{
"bool":{
"must":{
"wildcard":{
"name":"*jeck*"
}
}
}
}
}
区间查询 range
select * from index_person where name = 'jeck' and sex = 'male' and (age<30 and age>40)
{
"query": {
"bool": {
"must": [
{"match":{"name": "jeck"}},
{"match": {"sex": "male"}},
{"range" : {"age" : {"gt" : 40,"lt":30}}}
]
}
}
}