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 vote204 views2 answers
Show slave status mysql
SQL
9 votes226 views4 answers
How to alter table column name in mysql
SQL
0 vote204 views1 answer
Mysql auto increment default value with prefix month and year
SQL
5 votes230 views4 answers
Upload database mysql command line
SQL
0 vote234 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote205 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
1 vote231 views1 answer
Age postgres
SQL
0 vote221 views2 answers
Search stored procedures
SQL
0 vote227 views1 answer
Mysql search like but first exact match
SQL
0 vote227 views4 answers
Postgresql between month
SQL