Search options: Sphinx extended queries syntax allows the following special operators to be used: * operator OR: hello | world * operator NOT: hello -world hello !world * field search operator: @title hello @body world * phrase search operator: "hello world" * proximity search operator: "hello world"~10 Here's an example query which uses all these operators: "hello world" @title "example program"~5 @body python -(php|perl) More information about extended syntax you can find at: http://sphinxsearch.com/doc.html#extended-syntax
The following field operators are available: @title - search in post or page title @body - search in post, page, comment body @category - search search in blog categories
Semi live update - "main+delta" scheme: To enable semi-live index updates also known as "main+delta" scheme, the plugin will create the following table in your MySQL database:
in MySQLCREATE TABLE wpsphcounter ( counterid INTEGER PRIMARY KEY NOT NULL, maxdocid INTEGER NOT NULL ); If your WordPress installation's table prefix is not "wp", substitute the correct value.
Top and last tags: In order to be able to store search statistics the plugin will run the following SQL query during the activation process:
in MySQLCREATE TABLE wp_sph_stats (
id int(11) unsigned NOT NULL autoincrement,
keywords varchar(255) NOT NULL default '',
dateadded datetime NOT NULL default '0000-00-00 00:00:00',
keywordsfull varchar(255) NOT NULL default '',
PRIMARY KEY (id),
KEY keywords (keywords)
);
If your WordPress installation's table prefix is not "wp", substitute
the correct value.
The plugin folder structure: ./cron - contains crontab scripts, see crontab instructions below; ./php - contains php classes and libs; ./tags - contains sphinx search tags implementation; ./templates - contains html templates, that you can change to suit more to your blog design;
How to automatically start Sphinx search daemon at boot: In Debian based systems i.e. Ubuntu: % update-rc.d "/path/to/bin/searchd --config /path/to/etc/sphinx.conf" defaults In Redhat based systems i.e. Fedora: % chkconfig --add "/path/to/bin/searchd --config /path/to/etc/sphinx.conf"




