Answer the question
In order to leave comments, you need to log in
How to make multiple or/and in sphinx?
I can't find examples of how to combine multiple or/and in multiple columns,
for example
WHERE (`id` = 1 and `category` = 2) OR (`id` = 2 and `category` = 3)
Answer the question
In order to leave comments, you need to log in
SELECT id, ((`id` = 1 and `category` = 2) OR (`id` = 2 and `category` = 3)) AS cond
WHERE cond > 0
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question