Searching with the Sphinx daemon and SphinxSE

After completing the other recipes in this chapter, this is the recipe where we actually get to see Sphinx doing something.

Getting ready

This recipe requires that we install and configure SphinxSE and the Sphinx daemon. See the previous recipes in this chapter for instructions.

In the previous recipe, we configured the Sphinx daemon to index and search a table called documents in the test database. For the purposes of this recipe and to match the previous recipe, we need to create this table with the following CREATE TABLE command:

CREATE TABLE documents (
    id SERIAL PRIMARY KEY,
    date_added TIMESTAMP,
    title VARCHAR(256),
    content TEXT
);

We also need to add some example data to the table. The 4399OS_09_documents.sql file, available from this book's website, will create the table and populate it with some example data. We can load the file using the following statement:

mysql -u user -p test < 4399OS_09_documents.sql

We'll need...