Spectacu.la Advanced Search

This plug-in provides you with more relevant search results than are currently
available to the normal WordPress search and it should also do so with less of a
performance hit on the db than the normal WordPress search. We use the MySQL
commands MATCH () AGAINST () as opposed to WordPress’ use of LIKE to do our
queries which are not as heavy on the db. The only issue we have with “match
against” is that we need an index on the columns we intend to search on.