I have a range of ranges I want to check an integer field against and I want to do something like if "value" > 100 and "value" < "300" and "value" > "600" and "value" < "700"
. And repeat that across 6 sets of ranges.
I can just write the above out 6 times, but it seems super inefficient, if anyone has pointers on a better structure it'd be appreciated
(Also I thought of a translate table, but that seems just as painful given it'll be ~8000 unique values to compare against!)