I need to clean up a column that has all types of weird characters with in the string data. The weird characters are pretty much these []!@#$%.&*`~^-_{}:;<>/\|()
I only need to allow [0-9], [a-z] but also accented characters due to some spanish words being included.
I've been looking at https://dev.mysql.com/doc/refman/8.0/en/regexp.html to try to devise a regex that might fit this but my regex foo is weak.
Is there anyway to clean these up without having to look for and replace the special characters individually while still leaving the accented characters?