Using full text search, you can search for terms, phrases (sequences of terms), or prefixes. You can also combine multiple terms, phrases, or prefixes into boolean expressions, or require that expressions appear near to each other with proximity searches.
You perform a full text search using a CONTAINS clause in either a WHERE clause or a FROM clause of a SELECT statement. You
can also perform a full text search as part of the IF search condition (for example,
SELECT IF CONTAINS...).
Term and phrase searching
Terms dropped from the index
Scoring full text search results
Tutorial: Performing a full text search on a GENERIC text index
Tutorial: Performing a fuzzy full text search
Tutorial: Performing a full text search on a NGRAM text index
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|