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 Kill a Process on a Port in Ubuntu