1. Once again modify the
sphinx-blog.conf
file to add/modify the options as highlighted next:source blog { type = mysql sql_host = localhost sql_user = root sql_pass = sql_db = myblog sql_query = \ SELECT id, title, content, UNIX_TIMESTAMP(publish_date) \ AS publish_date, author_id FROM posts sql_attr_uint = author_id sql_attr_multi = uint category_id from query; \ SELECT post_id, category_id FROM posts_categories sql_attr_timestamp = publish_date sql_query_info = SELECT id, title FROM posts WHERE ID=$id } index posts { source = blog path = /usr/local/sphinx/var/data/blog docinfo = extern charset_type = sbcs } indexer { mem_limit = 32M }
2. Run the
indexer
again to re-index the data:$ /usr/local/sphinx/bin/indexer --config /usr/local/sphinx/etc/sphinx-blog.conf all
3. Search for all posts containing the term "language" and having the category "Search"
(category_id = 5):
$ /usr/local/sphinx/bin/ search --config /usr/local/sphinx/etc/sphinx-blog...
Sphinx Search Beginner's Guide
By :
Sphinx Search Beginner's Guide
By:
Overview of this book
Table of Contents (15 chapters)
Sphinx Search
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Setting Up Sphinx
Getting Started
Indexing
Searching
Feed Search
Property Search
Sphinx Configuration
Customer Reviews