Elasticsearch 类比 mysql 实现 in and like or

• or

select * from user where about=‘中华人民共和国‘ and firstName=‘王’
QueryBuilders.boolQuery().should(QueryBuilders.termQuery("about","中华人民共和国")).should(QueryBuilders.termQuery("firstName","王"))

• and or 连用

select * from user where  firstName=‘张‘ and( firstName=‘王’ or about=‘中华人民共和国公民‘)

QueryBuilders.boolQuery()
                        .must(QueryBuilders.termQuery("firstName","张"))
                        .must(QueryBuilders.boolQuery()
                                        .should(QueryBuilders.termQuery("firstName","王"))
                                        .should(QueryBuilders.termQuery("about","中华人民共和国公民"))

• like

select * from user where about like ‘%中华%‘


QueryBuilders.wildcardQuery("about","*中华*")

• in

select * from user where about in (‘中华人民共和国‘,‘中华人民共和国公民‘)

QueryBuilders.boolQuery()
                        .should(QueryBuilders.termQuery("about","中华人民共和国"))
                        .should(QueryBuilders.termQuery("about","中华人民共和国公民"))

Elasticsearch 类比 mysql 实现 in and like or

标签：查询方式   sele   code   tran   rgba   方式   mys   查询   elastic