B
B
beginer1232016-09-28 20:22:17
MySQL
beginer123, 2016-09-28 20:22:17

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

using sqlite

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Entelis, 2016-09-28
@DmitriyEntelis

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 question

Ask a Question

731 491 924 answers to any question