Will there be any indexing engine incorporated in the future ?
Depending on SQL's 'like' is very time consuming and resource consumptive , especially there are millions of posts in the DB.
Incorporating 3rd party indexing engine , such as
Lucene , can greatly simplify the search job.
Apache Lucene also has PHP bindings.