Sql take substring using Regexp?

Question

MySQL

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 1

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