Hi Jonas, It seems to me that you only need the path in your query:
DELETE FROM Folders WHERE path LIKE 'C:\MP3\Albums\%'; Alternatively you could keep parentid and just the appended path, ie: folderid parentid path 1 0 C:\MP3\Albums\ 2 1 Abba - Definitive Collection\ 3 2 cd1\ 4 2 cd2\ But the query to recursively delete would be more difficult. Tom BareFeet _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
