On 10/16/2014 12:03 PM, Tom Holden wrote:
I need a way to convert the text result to an expression that WHERE
evaluates as an expression.
Any possibility to do this within SQLite?
with recursive split(str, tail) as (
select null, 'string1+string2+string3'
union all
select substr(tail, 1, instr(tail || '+', '+')-1), substr(tail,
instr(tail || '+', '+') + 1)
from split where tail != ''
)
select * from mytable where not exists (
select str from split
where str is not null and value not like '%' || str || '%'
);
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
