IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

Searching for terms in any sequence

You can have more than one term in a search argument. One way to combine several search terms is to connect them together using commas, like this:

SELECT AUTHOR,TITLE
        FROM DB2EXT.TEXTTAB
        WHERE CONTAINS(COMMENT,
          '("kid", "dinosaur")') = 1
 

This form of search argument finds text that contains any of the search terms. In logical terms, an OR operator connects the search terms.


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