Bulk remove tags?

[Jiří Fiala]

I have used a 3rd-party script to add Jellyfin tags (not ID3 tags!) to my collection (goal was the ability to search movies by country, which JF lacks). It has gone overboard and I ended up with hundreds of useless tags.

Any way to completely wipe them? I tried the builtin Metadata view in JF but that just spins indefinitely.

Thanks

[TheDreadPirate]

Try Musicbrainz Picard? I think it should remove and replace the tags.

[Jiří Fiala]

I meant Jellyfin tags, not ID3 tags. I'll reword the OP.

[paulc]

Doesn't Tiny Media Manager let you bulk edit? Maybe bulk delete tags with it

[Jiří Fiala]

I was able to hack it by manually editing the JF sqlite database... thanks all

[pcm]

I was able to hack it by manually editing the JF sqlite database... thanks all

do you mind sharing the SQL queries ? Sounds like a handy thing to have ... I am about to go on a automated tagging-spree myself and doesn't hurt to have something like this handy.

[Jiří Fiala]

I think it was

DELETE FROM TypedBaseItems
WHERE Tags IS NOT NULL

I had to look up SQL queries on Youtube, I'm not a developer or db guy. But it wasn't so bad. I used SQLiteStudio (free, multiplatform).

[pcm]

thanks!