/SQL/How to remove characters from string in mysql

How to remove characters from string in mysql

#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-', '');

Similar codes

-1 vote127 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote131 views1 answer
Oracle exchange subpartition
SQL
0 vote133 views1 answer
Mysql to get column name in database
SQL
0 vote137 views1 answer
Sql doesn't contain
SQL
1 vote194 views1 answer
Mysql stop password policy
SQL
0 vote135 views1 answer
Mysql subdate
SQL
0 vote141 views1 answer
Stratified sampling sql
SQL
0 vote141 views1 answer
How to convert external table to managed table in hive
SQL
0 vote135 views1 answer
Apex for oracle 11g
SQL
0 vote143 views1 answer
Into operator in sql
SQL