sqlite select split string

Solutions on MaxInterview for sqlite select split string by the best coders in the world

Search
showing results for - "sqlite select split string"
Ilaria
30 Jul 2017
1-- using your data table assuming that b3 is suppose to be b2
2
3WITH split(one, many, str) AS (
4    SELECT one, '', many||',' FROM data
5    UNION ALL SELECT one,
6    substr(str, 0, instr(str, ',')),
7    substr(str, instr(str, ',')+1)
8    FROM split WHERE str !=''
9) SELECT one, many FROM split WHERE many!='' ORDER BY one;
10
11a|a1
12a|a2
13a|a3
14b|b1
15b|b2
16c|c2
17c|c1
source
similar questions
sqlite order randomcreate table split string function in sql serversqlite import sql scriptoracle split stringdescribe in sqlite3sql server 2016 split stringsqlite import sql filesql split string by spacesqlite to csv statementmql5 split stringsplit string by comma in sql serverhow to save result of sqlite query in a tablesqlite send a query to a sqlite db with rubymysql split stringsqlite trimsqlite execute from filesql server split string and insert into table selectsql split comma separated string into rows
queries leading to this page
string split sqlitesqllite 3 string splitsqlite split string by delimiterpython sqlite string functionssqlite split on charactersqlite split string into rowssplit string in sqllitesplit data in sqlitesqlite utils splitseqlite select part of value after charactersql split sqlitesqlite string functionssqlite split stringsqlite split string into columnssqlite splitsqlite3 split stringsplit string sqlitesqlite with splitsplit sqlitesplit string into columns sqlitelite sql string 28 29split string sqllitesqlite3 select after stringsqlite string splitsqlite select split string