Full-Text Search-Conditions
Previous  Top  Next


A full-text search-condition is basically a list of keywords, separated by "+", "," or "-". These characters mean:
,   both keywords must occur in the record
+   one of the keywords must occur in the record
-   the keyword must not occur in the record

The keyword itself can contain the jokers "?" and "*" to represent any single character or any substring respectively.

Here are some examples for valid full-text search-conditions:
Database         Finds Database, database, dataBase, ...
Database*         Finds database, Databases, DatabaseDriver, ...
Data?ase         Finds Database, dataCase, ...
Database, Driver         Record must contain the words Database and Driver
Database, Driver, ODBC      Record must contain the words Database, Driver and ODBC
Database + Driver      Record must contain either the word Database or the word Driver or both
Database + Driver + ODBC   Record must contain either the word Database or the word Driver or the word ODBC
-Database         Record must not contain the word Database
Database - Driver      Record must contain the word Database but not the word Driver