全文検索条件式の指定例を次に示します。なお,例では表「reports」のFREEWORD型の列「fword」を検索対象としています。
SELECT COUNT(*) FROM reports
WHERE contains(fword, '{"COMPUTER"}' ) IS TRUE
SELECT title FROM reports
WHERE contains(fword, '{SYNONYM(USR01, "COMPUTER")}' ) IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(fword, '{SYNONYM(USR01, "COMPUTER")
AND "NETWORK"}' ) IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(fword, '{SYNONYM(USR01,
"COMPUTER") AND SYNONYM(USR01,
"NETWORK")}' ) IS TRUE
SELECT title FROM reports
WHERE contains(fword, '{PROXIMITY(SYNONYM
(USR01, "COMPUTER"),<=10, CHARACTERS,
ANY_ORDER,SYNONYM(USR01,
"NETWORK"))}' ) IS TRUE
SELECT title, author FROM reports
WHERE contains(fword, '{PROXIMITY(SYNONYM
(USR01, "COMPUTER"),<= 20, CHARACTERS,
ANY_ORDER, SYNONYM( POLITICS,
"NETWORK"))}' ) IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(fword, '{"COMPUTER"} AND {"NETWORK"}' ) IS TRUE
SELECT COUNT(*) FROM reports
WHERE contains(fword, '{SOUNDEX_EXP("COMPUTER","AE") AND
SOUNDEX_EXP("NETWORK","AE")}' ) IS TRUE