Using SQLite
, I'd like to split a string in the following way.
Input string:
C:UsersfidelDesktopTemp
and have the query return these rows:
C:
C:Users
C:Usersfidel
C:UsersfidelDesktop
C:UsersfidelDesktopTemp
In other words, I'd like to split a file path into its constituent paths. Is there a way to do this in pure SQLite?
See Question&Answers more detail:os