In order to implement a search engine, we need to make provision for multiple columns to be included in the search. In addition, it's important to recognize that the search item might be found in the middle of the field, and that very rarely will users provide enough information for an exact match. Accordingly, we will rely heavily on the SQL
LIKE %value% clause.
>, and so on); and optionally an item. The reason why an item is optional is that some operators, such as
IS NOT NULL, do not require specific data:
namespace Application\Database\Search; ...