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 vote273 views1 answer
MySQL import data from large CSV file
SQL
3 votes291 views3 answers
Mysql auto increment after delete
SQL
3 votes280 views1 answer
Select database in sql
SQL
0 vote296 views1 answer
Copying query result to excel
SQL
0 vote280 views1 answer
Mysql 1 hour ago
SQL
0 vote269 views1 answer
Mysql identified by syntax error
SQL
6 votes283 views3 answers
Commit in sql
SQL
3 votes275 views2 answers
Monthname sql
SQL
11 votes280 views1 answer
Mysql text type max length
SQL
0 vote277 views1 answer
Best way to bind parameters to SqlCommand C#
SQL