Skip to main content

MATCH Operator

Standard SQL has an operator called MATCH. This operator allows performing full text search on one or more tables.

Loading...
Index Building

Full text search requires first creating and building an index. However, there is no need to explicitly write logic for it. It is automatically integrated into the SQL evaluation process such that the first time full text search is performed, it goes through this process of building the index. Building the index can take several seconds based on the amount of data.

Search specific fields​

Loading...

Extra Where Clause​

Loading...

Search Score​

Loading...
Sorting

By default the results are sorted based on the relevancy score. However, the results can be sorted using the ORDER BY clause using other fields.

With JOIN​

Loading...