how to use Sphinx for two different searches

In my website, I have integrated search which uses Sphinx at backend. Everything works
fine. You can say it as a Main Search

Now I want to add another search for NEWS module only. You can say it a mini search. This
search only search records within NEWS page, whereas the

main search(mentioned above) is searching the content in all cms pages.

For my main search I have SPHINX folder on the root of my drive which has one source and
one index. Here is the content of my .conf file.

source drupal_search
                type = mysql
                sql_host = localhost
                sql_user = root
                sql_pass =
                sql_db = sc
                sql_port = 3306
              sql_query = select n.nid as ID, n.title, n.status, n.created, f.field_body_value ,
              f.bundle\ from node n \ inner join field_data_field_body f on (n.nid = f.entity_id)\
              where n.status = 1\ ;

              sql_attr_timestamp = created
              sql_attr_uint = status
              sql_field_string = bundle
              sql_attr_string = type
              sql_query_pre = SET NAMES utf8


index drupal_search
        source = drupal_search
                path = C:\sphinx5\data\drupal_search
        docinfo = extern
        charset_type = utf-8

Open in new window

Now what is the best approach to add secondaRY SEARCHnews for NEWS Module.
Can I make another .conf file?
Yuri BoyzSoftware EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.