Answer the question
In order to leave comments, you need to log in
Sql take substring using Regexp?
Hello, there is a column with lines like this
a=aaa111&b=bbb2222&c=ccc3333
a=aaaa1111&b=bbbb22222&c=cccc33333
........................
..... ............
How to make a select through sql that will return 3 columns
a b c
aaa111 bbb2222 ccc3333
aaaa1111 bbbb22222 cccc33333
Answer the question
In order to leave comments, you need to log in
stackoverflow.com/questions/33874402/sqlite-regula...
you can write a query like
select (select ... ) as a, (select ... ) as b, ...
but imho it's easier to cut on any PL
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question