As of version 1.1.3, dbFront transparently supports Full-Text search for MySQL, Oracle and SQL Server. Full-Text search is classified as Enterprise functionality.
dbFront will automatically detect the Full-Text indexes and adjust queries to take advantage of any Full-Text indexes it knows about. This happens automatically in both Simple Search and in the Advanced Search.
Knowledgable users can construct advanced full-text search queries to take advantage of their specific database server. dbFront automatically detects advanced queries and processes them accordingly.
dbFront allows users to add a search prefix to force how the search is sent to the database. A search can be prefixed with "L:" to force the search to be treated as a simple LIKE query. Other prefixes are database specific.
MySql Full-Text Search can be run in three different modes:
- Boolean (B:), Natural Language (N:) and Query Expansion (E:).
Oracle Text Search has a single flexible mode:
SQL Server Full-Text Search can be run in two different modes:
- Contains (C:) and FreeText (F:).
For more details see: Full-Text Search