IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

Searching and returning the number of matches found

Use the NUMBEROFMATCHES function to determine how often the search value is found in each text document.

SELECT AUTHOR,TITLE,
        NUMBEROFMATCHES(COMMENT, '"book"')
        FROM DB2EXT.TEXTTAB
 

NUMBEROFMATCHES returns an integer value.


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