IMG-20220104-WA0002.jpg

The query should be

WHERE path LIKE

instead of

filename

Okay, but i want to find the path 😅

You cannot recursively crawl the entire disk looking for arbitrary files. You need to have an idea of where items are generally located to use the

file

table while using LIKE statements otherwise you will run into incomplete output due to symlink loops, or onerous runtimes due to the difficulty of crawling the whole disk.

Ok got it, Thanks @fritz