/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 vote143 views1 answer
Sql server list locks
SQL
1 vote134 views2 answers
Mysql spring boot application.properties
SQL
0 vote169 views1 answer
Python mysql executemany
SQL
0 vote135 views1 answer
Sql server bool select
SQL
0 vote143 views4 answers
How to connect form to database
SQL
0 vote145 views1 answer
How to query without duplicate rows in sql
SQL
1 vote135 views1 answer
Mysql server does not start mac
SQL
0 vote96 views1 answer
Check id exist or not in sql
SQL
1 vote139 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote150 views1 answer
How to login to mysql in homestead
SQL