Getting records from a table based on a filter field and Between but also having the OR login for mu
- by Pentium10
I have a this table, where I store multiple ids and an age range (def1,def2)
CREATE TABLE "template_requirements" ("_id" INTEGER NOT NULL,
"templateid" INTEGER,
"def1" VARCHAR(255),
"def2" VARCHAR(255),
PRIMARY KEY("_id"))
Having values such as:
templateid | def1 | def2
100 | 7 | 25
200 | 40 | 90
300 | 7 | 25
300 | 40 | 60
as you see for templateid 300 we have an or logic: age between 7 and 25 or age between 40 and 60.
I want to get all the template ids that are not for a certain age like 25...
What's the problem?
If I run a query like this one:
SELECT group_concat(templateid) FROM template_requirements where
and '25' not between cast(def1 as integer) and
cast(def2 as integer)
it returns 200, 300, which is wrong, as the 300 matched on row 40 to 60, but shouldn't be included in the result as we have a condition with same templateid 7 to 25 that fails the not beetween stuff.
How would be the correct query in SQLite, I would like to keep the group_concat stuff.
