Coreseek/sphek multiple query conditions

Source: Internet
Author: User
Coreseeksphinx full-text indexing using coreseek/sphek for multiple query conditions. for mysql source, my SQL statement is
Select * from tb where a like '% B %' and d like '% e %'
Some people say that two full-text index fields are created for an index.
But I don't know how to use the api
Is there any other way to know about it? let's say thank you.


Reply to discussion (solution)

Waiting for answers online

Too complicated? Now, can you? I? Discuz source ?,? According to his practice, his practice? Yes? .

Is there a solution?

The SQL statement in your configuration file uses like? Then we can use indexes to make hair...

Mysql like is very inefficient, so the source definition of the configuration file is not to use such a complex where condition, directly retrieve the id, and then use the ID to the database to retrieve other field information. In addition, you can define the fields to be used on the index file attributes so that you no longer need to retrieve database data.

It is recommended that first learning: http://www.coreseek.cn/products/products-install/

Thank you for your answer. although it is useless to me, I used the extended mode to explain what kind of query I want.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.