IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

Searching for terms in the same sentence or paragraph

Here is an example of a search argument that finds text documents in which the search terms occur in the same sentence:

SELECT AUTHOR,TITLE
        FROM DB2EXT.TEXTTAB
        WHERE CONTAINS(COMMENT,
           '"web" IN SAME SENTENCE AS "disk"') = 1
 

You can also search for more than two words occurring together. In the next example, a search is for two words occurring in the same paragraph:

SELECT AUTHOR, TITLE
        FROM DB2EXT.TEXTTAB
        WHERE CONTAINS(COMMENT,
           '"computer" IN SAME PARAGRAPH AS "web"') = 1
 


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]