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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » Querying data » Full text searching

 

Performing a full text query

You can perform a full text query by using the CONTAINS clause in the FROM clause of a SELECT statement, or by using the CONTAINS search condition (predicate) in a WHERE clause. Both return the same rows; however, the CONTAINS clause also returns scores for the matching rows.

For example, the following two statements query the Description column in the MarketingInformation table, and return the rows where the value in the Description column contains the term cotton. The second statement also returns scores for the matching rows.

SELECT *
   FROM MarketingInformation
   WHERE CONTAINS ( Description, 'cotton' );
SELECT *
   FROM MarketingInformation 
   CONTAINS ( Description, 'cotton' );

See FROM clause, and CONTAINS search condition.