dbFront version 1.1.3 supports Full-Text search on Text fields. Full-Text search is Enterprise functionality.
Using Full-Text search it is easy to construct a query that returns multiple values using the OR syntax.
Assuming you are looking for the values: red, green, blue, yellow, then the queries would be constructed as follows:
MySql: "B:red green blue". Note: The prefix "B:" forces advanced Boolean search in MySQL.
Oracle: "red OR green OR blue". Note: OR can be replaced with the pipe | or the comma ",".
SQL Server: "red OR green OR blue". Note: OR can be replaced with the pipe | character.
For more details see: Full-Text Search