Find between a list of values
From: <gandalf.corvotempesta_at_gmail.com>
Date: Sat, 31 Mar 2018 01:42:32 -0700 (PDT)
Message-ID: <c83b4b88-588e-4478-9307-26f8e7a8dadf_at_googlegroups.com>
[Quoted] Let's assume something like this:
Date: Sat, 31 Mar 2018 01:42:32 -0700 (PDT)
Message-ID: <c83b4b88-588e-4478-9307-26f8e7a8dadf_at_googlegroups.com>
[Quoted] Let's assume something like this:
start1,stop1|start2,stop2|start3,stop3
[Quoted] [Quoted] I would like to select all rows having a defined value (in example "1325" between one of the each group, in other words:
WHERE
(
( 1325 BETWEEN start1 AND stop1 )
OR ( 1325 BETWEEN start2 AND stop2 )
OR ( 1325 BETWEEN start3 AND stop2 )
)
[Quoted] Is this possible, with a single query using indexes ? It should be pretty fast.
I don't know how many "groups" are stored in the field. It could be 1:
start1,stop1
2:
start1,stop1|start2,stop2
or more.... Received on Sat Mar 31 2018 - 10:42:32 CEST