How create a function in SQLite that split comma separated values. Here is the same question but it is for MySQL.I want to do same thing in SQLite.
I tried this answer but I had no success.
Asked
Active
Viewed 429 times
2
-
1Is it worth the effort? Wouldn't be easier to just store the data in a usable format? – Álvaro González May 08 '13 at 10:39
-
1http://comments.gmane.org/gmane.comp.db.sqlite.general/67585 – Rachel Gallen May 08 '13 at 11:02
-
@RachelGallen there is split(c2, ';') function,but it not inbuit function & there is no any additional info about it. – user2251725 May 08 '13 at 12:33
-
@user2251725 bah humbug thought i was onto something there – Rachel Gallen May 08 '13 at 12:35