php - 如何将 MySQL 搜索条件转换为 Elasticsearch 查询

Question

我正在尝试将 MySQL 搜索条件转换为 Eleasticsearch(版本 7)查询，但是，这两个查询(MySQL 和 Elasticsearch)给出了不同的结果。在 SQL 语句上，它显示单条记录，而在 Elasticsearch 上，它显示 0 条记录。非常感谢任何帮助或指导。

SQL 条件

COUNT(*) WHERE (document_title like '%never listened%' or document_content like '%never listened%') and documnent_tone = 'negative'

转换为 Elasticsearch - 使用 PHP Elasticsearch 库

use Elasticsearch\ClientBuilder;
...

$elasticServer = $this->getOption('elasticsearch')->getElasticServer1();
$hosts = array(
    $elasticServer['host'] . ':' . $elasticServer['port']
);
$client = ClientBuilder::create()
    ->setHosts($hosts)
    ->build();

$params = array (
    "index" => "index_politics",
    "body" => array(
        "query" => array(
            "bool" => array(
                "must" => array(
                    array(
                       "wildcard" => array(
                            "document_title" => "never listened",
                        )
                    ),
                    array(
                       "wildcard" => array(
                            "document_content" => "never listened"
                        )
                    ),
                    array(
                        "match" => array(
                            "document_tone" => "negative"
                        )
                    )
                )
            )
        )
    )
);

$response = $client->count($params);
$negative = $response['count'];

var_dump($negative);

Answer 1

经过大量挖掘，以下内容对我有用

use Elasticsearch\ClientBuilder;
...

$elasticServer = $this->getOption('elasticsearch')->getElasticServer1();
$hosts = array(
    $elasticServer['host'] . ':' . $elasticServer['port']
);
$client = ClientBuilder::create()
    ->setHosts($hosts)
    ->build();

$params = array (
    "index" => "index_politics",
    "body" => array(
        "query" => array(
            "bool" => array(
                "must" => array(
                    array(
                        "multi_match" => array(
                            "query" => "never listened",
                            "fields" => array("document_title", "document_content")
                        )
                    )
                ),
                "filter" => array(
                    "term" => array(
                        "document_tone" => "negative"
                    )
                )
            )
        )
    )
);

$response = $client->count($params);
$negative = $response['count'];

var_dump($negative);

转换为 Elasticsearch 查询

GET /index_politics/_count
{
  "query": {
    "bool": {
      "must": [
        {
          "multi_match": {
            "query": "never listened",
            "fields": [
              "document_title",
              "document_content"
            ]
          }
        }
      ],
      "filter": {
        "term": {
          "document_tone": "negative"
        }
      }
    }
  }
}