Sqlite select split string

-- using your data table assuming that b3 is suppose to be b2

WITH split(one, many, str) AS (
    SELECT one, '', many||',' FROM data
    UNION ALL SELECT one,
    substr(str, 0, instr(str, ',')),
    substr(str, instr(str, ',')+1)
    FROM split WHERE str !=''
) SELECT one, many FROM split WHERE many!='' ORDER BY one;

a|a1
a|a2
a|a3
b|b1
b|b2
c|c2
c|c1

Source: stackoverflow.com

Similar codes

0 vote115 views2 answers
Sqlite unique
SQL
5 votes113 views2 answers
Sql number columns
SQL
0 vote137 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote131 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote111 views1 answer
How to find symmetric pairs in sql
SQL
2 votes107 views1 answer
Plsql block
SQL
0 vote121 views1 answer
Linked server delete openquery
SQL
6 votes166 views2 answers
How to get last element sql
SQL
0 vote167 views1 answer
Delete from IN subquery
SQL
1 vote112 views1 answer
Mysql connect bash
SQL