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.