Replace part of a field with replace in Mysql _mysql

A friend recently mentioned how to use SQL to delete a section of a field, so I wrote this article, simple demerit:

The test table is as follows:

Copy Code code as follows:

CREATE TABLE ' t ' (
' ID ' int (a) unsigned not NULL auto_increment,
' Domain ' Tinytext,
PRIMARY KEY (' id ')
) Engine=myisam auto_increment=2 DEFAULT Charset=utf8

Insert Test content:

Copy Code code as follows:

INSERT into t (domain) VALUES (' j054,j020,mc032,her302 ')

Replace table contents:

Copy Code code as follows:

UPDATE t SET domain = (REPLACE (domain, ', her302 ', ')) WHERE id = 1

View Replacement Results