how to remove characters from string in mysql

The solution for this is noted below

how to remove characters from string in mysql

Solution

#query
UPDATE tableName SET columnName = REPLACE(columnName, 'charactersToBeReplaced', 'charactersToBeReplacedWith');

#you can use like this
UPDATE student_enroll_data SET student_name = REPLACE(student_name, '-gyg-', '');

Try other methods by searching on the site. That is if this doesn’t work