I ended up scheduling 3 SQL queries in myphpadmin. Couldn’t manage to get it into a single update command. Nested replace only works with select, and my version of MariaDB does not support regex and wildcards.
I used spotterid instead of poster to limit enabling spam in Sonarr.
Remove NL Subs from QoQ Series:
UPDATE spots SET title= REPLACE (title, ’ NLSubs ', ’ ') WHERE spotterid = ‘C7w1uw’ AND subcatz = ‘z1|’
Remove (2015) from QoQ Series:
UPDATE spots SET title= REPLACE (title, ‘(2015)’, ‘’) WHERE spotterid = ‘C7w1uw’ AND subcatz = ‘z1|’
Remove (2016) from QoQ Series:
UPDATE spots SET title= REPLACE (title, ‘(2016)’, ‘’) WHERE spotterid = ‘C7w1uw’ AND subcatz = ‘z1|’
As for the posts by Molly, it would be hard to replace her naming schema automatically as she (I assume) is inconsistent as hell.
afl.3
Se.1afl.3
Se.1 afl.3
SE.2 afl.3
Serie 2 afl.2
Everything would need it’s own query, and I have no idea how much that would impact the performance of the machine.
The best I can come up with is:
1 query to replace ’ afl.’ to E0 (Not sure if Sonarr will properly pass E010 though)
1 query to replace ‘afl.’ to E0 (Not sure if Sonarr will properly pass E010 though)
1 query per season replace, so replace ‘Se.’ to ‘S0’ (Not sure if Sonarr will properly pass S010 though, ‘SE.’ to ‘S0’,
'Serie ’ to ‘S0’, etc.
As update is permanent, you would need to test that on a separate database though, to make sure it doesn’t screw things up.