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.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |