Search Functions

SELECT META(t1).id
FROM airline AS t1
WHERE SEARCH(t1.country, "+United +States");

SELECT META(t1).id
FROM airline AS t1
WHERE SEARCH(t1, "country:\"United States\"");

[

  {
    "id": "airline_10"
  },
  {
    "id": "airline_10123"
  },
  {
    "id": "airline_10226"
  },
  {
    "id": "airline_10748"
  },
  // ...
]

SELECT t1.name
FROM hotel AS t1
WHERE SEARCH(t1, {
  "match": "bathrobes",
  "field": "reviews.content",
  "analyzer": "standard"
});

[
  {
    "name": "Typoeth Cottage"
  },
  {
    "name": "Great Orme Lighthouse"
  },
  {
    "name": "New Road Guest House (B&B)"
  },
  // ...
]

SELECT t1.name
FROM hotel AS t1
WHERE SEARCH(t1, {
  "explain": false,
  "fields": [
     "*"
   ],
   "highlight": {},
   "query": {
     "match": "bathrobes",
     "field": "reviews.content",
     "analyzer": "standard"
   },
   "size" : 5,
   "sort": [
      {
       "by" : "field",
       "field" : "reviews.ratings.Overall",
       "mode" : "max",
       "missing" : "last"
      }
   ]
});

[
  {
    "name": "Waunifor"
  },
  {
    "name": "Bistro Prego With Rooms"
  },
  {
    "name": "Thornehill Broome Beach Campground"
  },
  // ...
]

SELECT META(t1).id
FROM hotel AS t1
WHERE t1.type = "hotel" AND SEARCH(t1.description, "amazing");

[
  {
    "id": "hotel_20422"
  },
  {
    "id": "hotel_22096"
  },
  {
    "id": "hotel_25243"
  },
  {
    "id": "hotel_27741"
  }
]

SELECT t1.color
FROM rgb AS t1
WHERE SEARCH(t1,
  {
    "fields": ["*"],
    "query": {
      "match_none": ""
    },
    "knn": [
      {
        "k": 2,
        "field": "colorvect_dot",
        "vector": [ 0.707106781186548, 0, 0.707106781186548 ]
      }
    ]
  }
)

[
  {
    "color": "magenta / fuchsia"
  },
  {
    "color": "dark lavender"
  }
]

SELECT META().xattrs.field
FROM `travel-sample` T
WHERE SEARCH(T, "_$xattrs.field:*");

[
  {
    "field": "field data"
  }
]

SELECT SMETA().fields.`_$xattrs.field`
FROM `travel-sample` T
LET SMETA = SEARCH_META()
WHERE SEARCH(T,
  { "query": {"query": "_$xattrs.field:*"}, "fields": ["_$xattrs.field"]},
  {"index": "travel-sample._default.xattrsTest"});

[
  {
    "_$xattrs.field": "field data"
  }
]

SELECT SEARCH_META() AS meta (1)
FROM hotel AS t1
WHERE SEARCH(t1, {
  "query": {
    "match": "bathrobes",
    "field": "reviews.content",
    "analyzer": "standard"
  },
  "includeLocations": true
}) (2)
LIMIT 3;

[
  {
    "meta": {
      "id": "hotel_12068", (1)
      "locations": { (2)
        "reviews.content": {
          "bathrobes": [
            {
              "array_positions": [
                8
              ],
              "end": 664,
              "pos": 122,
              "start": 655
            }
          ]
        }
      },
      "score": 0.3471730605306995 (3)
    }
  },
  // ...
]

SELECT t1.name, SEARCH_META(s1) AS meta (1)
FROM hotel AS t1
WHERE SEARCH(t1.description, "mountain", {"out": "s1"}) (2)
AND SEARCH(t1, {
  "query": {
    "match": "bathrobes",
    "field": "reviews.content",
    "analyzer": "standard"
  }
});

[
  {
    "name": "Marina del Rey Marriott"
  }
]

SELECT name, description, SEARCH_SCORE() AS score (1)
FROM hotel AS t1
WHERE SEARCH(t1.description, "mountain")
ORDER BY score DESC
LIMIT 3;

[
  {
    "description": "3 Star Hotel next to the Mountain Railway terminus and set in 30 acres of grounds which include Dolbadarn Castle",
    "name": "The Royal Victoria Hotel"
  },
  {
    "description": "370 guest rooms offering both water and mountain view.",
    "name": "Marina del Rey Marriott"
  },
  {
    "description": "This small family run hotel captures the spirit of Mull and is a perfect rural holiday retreat. The mountain and sea blend together to give fantastic, panoramic views from the hotel which is in an elevated position on the shoreline. Panoramic views are also available from the bar and restaurant which serves local produce 7 days a week.",
    "name": "The Glenforsa Hotel"
  }
]