Home  »  CodeLibrariesSnippetsTechnology   »   Remove Character From String in MySQL Code

Remove Character From String in MySQL Code

Posted: May 11, 2022 | by Site Host

Use this snippet to remove character from string.

Query format:

UPDATE tableName SET columnName = REPLACE( columnName, 'charactersToBeReplaced', 'replacementCharacters' );

Example:

; first_name is 'Tomny'

UPDATE users SET first_name = REPLACE( first_name, 'n', 'm' ) WHERE id > 0;

; result: first_name is now 'Tommy' 

Found this article interesting? Follow Brightwhiz on Facebook, Twitter, and YouTube to read and watch more content we post.

Share it!

See also  How to Display Text With Multiple Colors in CSS