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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Queries and data modification » 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 are 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 Performing Full Text Searches on Chinese, Japanese, and Korean Data in SQL Anywhere 11 white paper at [external link]

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

Creating a text configuration object (Sybase Central)
Altering a text configuration object
Viewing a text configuration object in the database
Creating a text index
Refreshing a text index
Alter a text index
Viewing text index terms and settings (Sybase Central)
Viewing text index terms and settings (SQL)