[Feature] Search file names by regex

[ChildishhAlbino]

I have searched the existing feature requests, both open and closed, to make sure this is not a duplicate request.

• Yes

The feature

I would like the option to search file names by a regex pattern. This would be very useful to remove loads of downloaded TikToks in my library that have no other identifying qualities outside of their filename being a specific length UUID.

I have tried using context search and even with additional filters it's too liberal and includes non-TikTok videos.

Platform

• Server
• Web
• Mobile

[bo0tzz]

You can use postgres LIKE syntax (https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-LIKE) in the search, does that cover what you're trying to do?

[ChildishhAlbino]

Not really - I need to be able to query for exactly 32 Alphanumeric characters. I don't see a way to do that using a LIKE matcher.

Regex also gives me the control to match only letters and numbers which the LIKE match syntax doesn't seem to allow.

[slackfan]

I agree that this would be helpful. My use case is similar. I have tons of photos from a certain source without proper album tagging (yet) and it is tricky to impossible to properly identify them within the app itself.

[MahrWe]

I was able to tag all my images using pattern matching. @bo0tzz comment led me to find postgres SIMILAR TO which allows for pattern matching.
Now I am trying to find a way to schedule this process with something like cron.
I would be happy for feedback, especially as I am not sure database queries are safe enough.

https://gist.github.com/MahrWe/ee563cc1134527506b8acff3234e74e9