Accessing Sphinx as a Database

Sphinx is a popular open source full text indexing engine which can be used to greatly improve search functionality over the full-text search options available in most databases. While adding this to the search function of a site recently, I stumbled upon some neat tricks that I would like to share with you.