復制代碼 代碼如下:

UPDATE `tran`
SET `status` = '1'
WHERE `msg` = '我愛你';

復制代碼 代碼如下:

UPDATE `tran`
SET `status` = '1'
WHERE trim( replace( `msg`, '/r/n', ' ' ) ) = '我愛你';

復制代碼 代碼如下:

UPDATE `tran`
SET `status` = '1'
WHERE trim( trim(
BOTH '/r/n'
FROM content ) ) = '我愛你'

復制代碼 代碼如下:

replace into table (id,name) values('1','a'),('2','b');