or  paragraph

Chapter 5: Writing Full-Text Search Queries

phrase

The phrase operator selects documents that contain a particular phrase (a group of two or more items that occur in a specific order). Each result is relevance-ranked. The following example selects the documents that contain the phrase “gorilla’s head”:

select t1.score, t2.copy
from i_blurbs t1, blurbs t2
where t1.id=t2.id and t1.score > 50
and t1.index_any = "<phrase>(gorilla’s head)"




Copyright © 2005. Sybase Inc. All rights reserved. paragraph

View this book as PDF