/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

2 votes137 views2 answers
Null column to 0 in mysql
SQL
0 vote103 views1 answer
How to check even or odd in sql
SQL
0 vote113 views1 answer
How to delete python anywhere mysql database
SQL
0 vote115 views1 answer
Excel export from sql using python
SQL
0 vote102 views1 answer
Sql character index
SQL
0 vote107 views1 answer
Check index sql server
SQL
0 vote119 views1 answer
Sql server convert to guid
SQL
0 vote110 views1 answer
Intellij mysql set timezone
SQL
0 vote116 views1 answer
Drop CHECK constraint sql
SQL
0 vote111 views1 answer
Postgres sequence name
SQL