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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Querying and modifying data » Full text search » How to perform a full text search


Boolean searching

You can specify multiple terms separated by Boolean operators when performing full text searches. SQL Anywhere supports the following Boolean operators when performing a full text search: AND, OR, and AND NOT.

For more information about the syntax for boolean searching, see CONTAINS search condition.

 Using the AND operator in full text searches
 Using the OR operator in full text searches
 Using the AND NOT operator in full text searches
 Combining different boolean operators
 Grouping terms and phrases
 Searching across multiple columns