“Like many companies, over the years my company developed a
home-grown billing/project system that allows our programmers to
bill to a Web application. This system is quite capable; however
one of the drawbacks to the system is that there’s no way to search
the billable entries or customer notes.“Of course, we could use simple LIKE or regex queries via SQL
but that would be resource-intensive and would not provide the
detailed results we would like. For example, to search for all
billing entries that had a description with the words ‘apache’ (to
protect the customer name) and ‘php’ we could write a query like
this