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