Elasticsearch 类比 mysql 实现 in and like or

"about","中华人民共和国")).must(QueryBuilders.termQuery("firstName","张")) 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   

查看更多关于Elasticsearch 类比 mysql 实现 in and like or的详细内容...