Remove Character From String in MySQL Code

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.