/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

13 votes240 views2 answers
Sql join 3 tables
SQL
0 vote232 views1 answer
Delete first row in sql
SQL
0 vote226 views1 answer
Mysql insert into select with recursive
SQL
0 vote223 views1 answer
Oracle sql generate list of days
SQL
0 vote232 views1 answer
Oracle current timestamp insert statement
SQL
0 vote242 views1 answer
.sql File Run in PSQL
SQL
0 vote234 views1 answer
Mysql regex select
SQL
0 vote248 views3 answers
How to increase size of column in sql
SQL
0 vote241 views1 answer
Oracle running queries
SQL
0 vote234 views1 answer
Mssql + bit + in python orm
SQL