Answers for "how to remove a substring from a 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-', '');

Posted by: Guest on May-18-2021

Code answers related to "how to remove a substring from a string in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to remove a substring from a string in mysql"

Code answers related to "how to remove a substring from a string in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to remove a substring from a string in mysql"

Code answers related to "how to remove a substring from a string in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us