{"id":454,"title":"elasticsearch\u5b9e\u73b0\u7c7b\u4f3c\u4e8esql\u7684like,or,and,in,\u5927\u4e8e\u7b49\u590d\u6742\u67e5\u8be2","good":0,"bad":0,"hit":2028,"created_at":"2020-04-05 14:11:57","content":"
\u57fa\u4e8e\u4e4b\u524d\u7684\u6570\u636e\uff0c\u6211\u4eec\u8981\u5b9e\u73b0\u4e00\u4e2a\u7c7b\u4f3c\u8fd9\u6837\u7684\u67e5\u8be2\uff1a<\/p>
select * from users \nwhere (name like '%\u5f20\u4e09%' or name like '%\u674e\u56db%') \n\tand sex=1 and city_id in (1,2)\n\tand (address like '%\u5e7f\u5dde%' or address like '%\u6df1\u5733%') \n\tand create_time>'2020-04-04 12:30:30'\norder by position desc\nlimit 10,2<\/pre>post \n\n match\u7528\u4e8etext\u5b57\u6bb5\u67e5\u8be2\uff0c\u5982\u679c\u6709\u591a\u4e2a\u6761\u4ef6\u4e2d\u95f4\u7528\u7a7a\u683c\u9694\u5f00\n term:\u5982\u679c\u662f\u7b49\u4e8e\u65f6\u7528\n terms:\u5982\u679c\u662fin\u64cd\u4f5c\u65f6\u7528\n\n\n{\n\t"from":0,\n\t"size":10,\n "query": {\n "bool": {\n "must": [\n {\n "match": {\n "name": "\u5f20\u4e09 \u674e\u56db"\n }\n },\n {\n \t"terms":{\n \t"sex":[1,2]\n }\n },\n {\n \t"terms":{\n \t"city_id":[1,2]\n }\n },\n {\n \t"match":{\n \t"city_name":"\u5e7f\u5dde \u6df1\u5733"\n }\n },\n {\n \t"range":{\n \t"create_time":{\n \t\t"gt":"2020-04-04 15:03:11"\n \t}\n }\n }\n ]\n }\n },\n "sort": [\n {\n "_geo_distance": {\n "location": {\n "lat": 23.265706,\n "lon": 113.261805\n },\n "order": "asc",\n "unit": "km"\n }\n }\n ],\n "highlight": {\n "pre_tags": [\n "<font color=red>",\n "<tag2>"\n ],\n "post_tags": [\n "<\/font>",\n "<\/tag2>"\n ],\n "fields": {\n "description": {}\n }\n }\n}<\/pre>
<\/p>\u67e5\u8be2\u7ed3\u679c\uff1a<\/p>
\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684sort\u4e3a\u8ddd\u79bb<\/p>
{\n "took": 4,\n "timed_out": false,\n "_shards": {\n "total": 1,\n "successful": 1,\n "skipped": 0,\n "failed": 0\n },\n "hits": {\n "total": {\n "value": 3,\n "relation": "eq"\n },\n "max_score": null,\n "hits": [\n {\n "_index": "student",\n "_type": "_doc",\n "_id": "B_PTRHEBHFJU5U-vVzVn",\n "_score": null,\n "_source": {\n "id": "3",\n "tel": "13533592803",\n "name": "\u5f20\u4e09",\n "sex": "1",\n "city_id": "2",\n "city_name": "\u5e7f\u5dde\u5e02",\n "location": {\n "lat": 23.265706,\n "lon": 113.261805\n },\n "create_time": "2020-04-04 16:03:12",\n "address": "\u5e7f\u4e1c\u7701\u5e7f\u5dde\u5e02\u5929\u6cb3\u5ba2\u8fd0\u7ad9"\n },\n "sort": [\n 0.0\n ]\n },\n {\n "_index": "student",\n "_type": "_doc",\n "_id": "BvPTRHEBHFJU5U-vVzVn",\n "_score": null,\n "_source": {\n "id": "2",\n "tel": "13533592802",\n "name": "\u5f20\u4e09\u82b1",\n "sex": "2",\n "city_id": "1",\n "city_name": "\u6df1\u5733\u5e02",\n "location": {\n "lat": 22.632069,\n "lon": 114.062088\n },\n "create_time": "2020-04-04 15:58:52",\n "address": "\u5e7f\u4e1c\u7701\u6df1\u5733\u5e02\u9f99\u5c97\u533a\u5742\u7530\u7ad9"\n },\n "sort": [\n 108.06943106175012\n ]\n },\n {\n "_index": "student",\n "_type": "_doc",\n "_id": "BfPTRHEBHFJU5U-vVzVn",\n "_score": null,\n "_source": {\n "id": "1",\n "tel": "13533592801",\n "name": "\u5f20\u4e09\u4e30",\n "sex": "1",\n "city_id": "1",\n "city_name": "\u6df1\u5733\u5e02",\n "location": {\n "lat": 22.719571,\n "lon": 114.364493\n },\n "create_time": "2020-04-04 15:57:20",\n "address": "\u5e7f\u4e1c\u7701\u6df1\u5733\u5e02\u9f99\u5c97\u533a\u576a\u5c71\u7ad9"\n },\n "sort": [\n 128.17103318459294\n ]\n }\n ]\n }\n}<\/pre>
<\/p>
<\/p>\u518d\u6765\u4e00\u4e2a\u4f8b\u5b50\uff1a<\/p>
{\n\t"from":0,\n\t"size":10,\n "query": {\n\t\t\t"bool":{\n "must":[\n {"match":{"vcc_id":"2000820"}},\n {"match":{"flow_id":"460"}},\n {"range":{"create_time":{"gte":"1547801073"}}},\n {"range":{"create_time":{"lte":"1642495473"}}},\n {\n "bool":{\n "should":[\n {"match":{"ticket_no":"460210118000001"}},\n {"match":{"client_phone":"13760139234"}},\n {"match":{"node_1715_form.nvPun11548055909540":"\u9102ley981"}},\n {"match":{"node_1715_form.bD8i5R1563328936844":"fuwukahao"}}\n ]\n }\n }\n ]\n }\n\t\t},\n "highlight": {\n "pre_tags": [\n "<font color=red>",\n "<tag2>"\n ],\n "post_tags": [\n "<\/font>",\n "<\/tag2>"\n ],\n "fields": {\n "description": {}\n }\n },\n "sort": [{\n\t\t\t"create_time": {\n\t\t\t\t"order": "desc",\n\t\t\t\t"unmapped_type": "date"\n\t\t\t}\n\t\t}]\n}<\/pre>
<\/p>"}