SQLite Forum

Extract files from sqlar with a directory prepended
Login
Does `($dir || name)` right after 'SELECT' do anything?

So `GLOB '*..[/\]*'` does match `abc../`? In other words, this glob can miss some legal paths?

Why is `(1)` needed?

If I want to ignore abspaths, I should add `AND NOT GLOB '/*'` at the end?