OR filter in WHERE

General Discussions - English
1

Hello, does Manticore supports already OR filtering in WHERE clause? On Sphinx forum I saw it’s suggested to use IF() in select as a workaround, but having OR would make queries nicer.
Thank you

2

OR filtering support was added ( see 76b04de).
Please note that is between attribute filters and not between MATCH and an attribute filters.so you can do
WHERE MATCH(‘something’) AND attr1> 10 OR attr2<10
but not
WHERE MATCH(‘something’) OR attr1> 10.
If you want to use it, you need to compile Manticore or wait until the next release.