|
|
|
Description
The full-text predicate can be used to search text based on a full-text index. If an IN predicate specifies a query expression, the result table it returns can contain only a single column. This predicate can be used inside a WHERE, HAVING, or JOIN statement.
Syntax
fulltext_predicate::
[ table_name. ] column MATCH phrase
phrase ::
token [ operator token [ operator token...] ... ]
operator ::
[ ^ | near | near/x | and | or | - ]
^ search from beginning of column (only one ^ allowed per query)
near multiple near terms allowed
near/x specify number of tokens to be within the target search token. Multiple near terms allowed.
and logical AND operator
NOTE: See Planned Features for which operators are implemented.
