Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Query and modify data » Full text search


What is full text search?

Full text search is a more advanced way to search a database. Full text search quickly finds all instances of a term (word) in a table without having to scan rows and without having to know which column a term is stored in. Full text search works by using text indexes. A text index stores positional information for all terms found in the columns you create the text index on. Using a text index can be faster than using a regular index to find rows containing a given value.

Full text search capability in SQL Anywhere differs from searching using predicates such as LIKE, REGEXP, and SIMILAR TO, because the matching is term-based, not pattern-based.

String comparisons in full text search use all the normal collation settings for the database. For example, if the database is configured to be case insensitive, then full text searches will be case insensitive.

Except where noted, full text search leverages all the international features supported by SQL Anywhere.

To perform a full text search on a database containing Chinese, Japanese, and Korean (CJK) data, see the white paper "Performing Full Text Searches on Chinese, Japanese, and Korean Data in SQL Anywhere 11" at [external link]

 Two ways to perform a full text search
 Considerations before using full text search
 See also