I'm using Editor. How can I create a condition with OR?
You would need a plugin for it. If you could design how it should look like then I'm willing to implement it.
This would be awesome.. when I get to an OR I have to click edit and do the rest manually.
Lemme see, maybe I can figure out how a UI would look.
In mysql: a AND b AND c OR d --> will match just D.
So that means we need groupings. Perhaps an indented group of ORs where only one of them needs to match? It won't satisfy really complicated cases of (a AND B) or C or D.
Oh. Groupings. So I have an idea of 1-depth groupings.
Add a plus button to create a new grouping. Then set that entire grouping (which is inside () in the SQL) as either an AND to the first one, or an OR. Within each grouping it's always AND.
Except, this way doesn't let you specify a "core" group that must be satisfied, then a group that's one OR the other. I'll attach my gui build, but it won't really work.
E.g. what I wanted was to pick usa OR uk. Perhaps we need another drop down next to each item, to choose AND/OR? That makes things much messier than they already are...
Maybe someone has a better idea. This is surely non-trivial. I couldn't find any screenshots of something that did this.
This is too complicated. You can easily search for 'uk', 'usa' with IN.