Given a table with a column called files_name, and you want to match everything after the match with regex, and replace it with nothing.
I have this code but it matches everything, but it's always changed 0.
UPDATE files SET files_name = REGEXP_REPLACE (files_name, 'S[0-9]?[0-9]?[0-9]E[0-9]?[0-9]\K.*', '') WHERE type = 5;
A online regex tester says my regex is correct, and is matching as desired, yet no matter what I put into the second
'' it never replaces the match.
I'm using mariadb 10.3.17