ES、正则表达式
以下示例中使用userPhones为条件来做测试,提供两种正则查询方式
1、根据字段值的长度来匹配数据
下面示例中.{11}表示查询userPhones参数值满足11位的数据。
{
"query": {
"regexp": {
"userPhones": {
"value": ".{11}"
}
}
}
}
2、根据正常的手机号格式来匹配数据
下面示例是查询11位以1开头的数字,并且前后都不是数字。
{
"query": {
"regexp": {
"userPhones": "[^0-9]*1[3-9][0-9]{9}[^0-9]*"
}
}
};
代码查询示例,其中.{}可以替换成[0-9]*1[3-9][0-9]{9}[0-9]*使用
public static void main(String[] args) {
// 创建 RestHighLevelClient 客户端
HttpHost host = new HttpHost("127.0.0.1", 9200, "http");
RestHighLevelClient client = new RestHighLevelClient(
RestClient.builder(host));
// 构建查询请求
SearchRequest searchRequest = new SearchRequest("project_evaluate");
SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
// 构建查询条件
searchSourceBuilder.query(QueryBuilders.regexpQuery("userPhones", ".{11}"));
// 可选:设置返回结果数量
searchSourceBuilder.size(10);
// 可选:设置超时时间
searchSourceBuilder.timeout(TimeValue.timeValueSeconds(5));
// 将查询条件添加到查询请求中
searchRequest.source(searchSourceBuilder);
try {
// 执行查询
SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);
// 处理查询结果
SearchHit[] hits = searchResponse.getHits().getHits();
for (SearchHit hit : hits) {
// 获取"userPhones"字段值
Map<String, Object> map = hit.getSourceAsMap();
System.out.println("userPhones: " + map.get("userPhones"));
}
} catch (IOException e) {
e.printStackTrace();
} finally {
// 关闭客户端连接
try {
client.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
ES官正则表达式使用规则,有需要了解的小伙伴可以去看看
https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-regexp-query.html
https://www.elastic.co/guide/en/elasticsearch/reference/current/regexp-syntax