Prefix Matching

You can use prefix substrings to search for strings or tokens starting with specific strings.

This example searches for all hotels starting with the word The :

FOR review IN sample_view
  SEARCH ANALYZER(STARTS_WITH(review.Property_Name, "The "), "identity")
  RETURN review.Property_Name

The result is a list starting with:

Property_Name
The Savoy
The Savoy
The Savoy
The Savoy
...

You can expand the search to include Hotel :

FOR review IN sample_view
  SEARCH ANALYZER(STARTS_WITH(review.Property_Name, "The ") OR STARTS_WITH(review.Property_Name, "Hotel "), "identity")
  RETURN review.Property_Name

You can also expand the search to include prefixes for multiple attributes. For example, all hotels starting with The and reviews starting with Awesome :

FOR review IN sample_view
  SEARCH ANALYZER(STARTS_WITH(review.Property_Name, "The ") AND STARTS_WITH(review.Review_Title, "Awesome "), "identity")
  RETURN {
  Property_Name : review.Property_Name,
  Review_Title : review.Review_Title
  }

The results display three reviews:

Property_Name	Review_Title
The Dorchester	Awesome luxury hotel
The Dorchester	Awesome Bathroom, great location, Superb service
The Savoy	Awesome Again