Phrase Search

​

Basic Usage

Searches for a specific phrase. Phrases must be wrapped inside double quotes. The following query finds all documents with the word plastic followed immediately by keyboard.

SELECT * FROM search_idx.search('description:"plastic keyboard"');

​

Slop Operator

The ~ slop operator allows for other words to come in between words in the query phrase. For instance, the following query finds documents containing the word ergonomic followed by keyboard, allowing for a maximum of one word in between.

SELECT * FROM search_idx.search('description:"ergonomic keyboard"~1');

​

Phrase Prefix

The * prefix operator allows for the last term in the phrase query to be the prefix of another word. For instance, "plastic keyb"* matches plastic keyboard.

SELECT * FROM search_idx.search('description:"plastic keyb"*');