/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

0 vote149 views1 answer
Postgres populate table from another table
SQL
0 vote158 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote156 views1 answer
Reona
SQL
0 vote154 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote231 views1 answer
Print hello world in plsql
SQL
0 vote191 views1 answer
Import sql inside hide sql
SQL
10 votes142 views4 answers
Primary key in sql
SQL
0 vote165 views1 answer
How to inner join 4 tables in sql
SQL
0 vote153 views1 answer
Mysql where in keep order
SQL
11 votes144 views2 answers
Oracle all source
SQL