To search for database rows (or files) that contain two or more words by relative proximity, use a Verity collection, and search for data using the NEAR and NEAR/n operators. NEAR ensures that the words are no more than 1000 words from each other, NEAR/n lets you specify the maximum distance. Results will be sorted so that the nearer the words the higher the relevancy rating. (Applies to: ColdFusion All)

Leave a Reply