select replace('aaaa','a','b')
select replace('aaaa','aa','b')
select replace('aaaa','a','bb')
select replace('aaaa','','b')
select replace('bbbb','a','c')
select replace(concat(lower(concat('THIS',' ','IS',' ','A',' ')),upper('false'),' ','test'),'FALSE','REAL') 
select replace('北京涛思','北京', '')
select replace('北京涛思','涛思', '')
select replace('北京涛思.com','思.', '北京')
select replace('北京涛思.com','北com', '北京涛')
select replace('北京涛思', char(ascii('北')), 'wrongans')
select replace(nch1, 'a', 'b') from ts_4893.meters order by ts limit 5
select replace(nch1, 'a', 'b') from ts_4893.meters where position('a' IN nch1) != 0 order by ts limit 5
select replace(nch1, 'a', 'b') from ts_4893.meters where position('a' IN nch1) = 0 order by ts limit 5
select replace(nch1, 'a', '啊') from ts_4893.meters order by ts limit 5
select replace(nch1, 'a', '啊') from ts_4893.meters where position('a' IN nch1) != 0 order by ts limit 5
select replace(nch1, 'a', '啊') from ts_4893.meters where position('a' IN nch1) = 0 order by ts limit 5
select replace(nch1, '一', '壹') from ts_4893.meters order by ts limit 5
select replace(nch1, '一', '壹') from ts_4893.meters where position('一' IN nch1) != 0 order by ts limit 5
select replace(nch1, '一', '壹') from ts_4893.meters where position('一' IN nch1) = 0 order by ts limit 5
select replace(nch1, '一', '1') from ts_4893.meters order by ts limit 5
select replace(nch1, '一', '1') from ts_4893.meters where position('一' IN nch1) != 0 order by ts limit 5
select replace(nch1, '一', '1') from ts_4893.meters where position('一' IN nch1) = 0 order by ts limit 5
select replace(nch1, nch2, 'nch2') from ts_4893.meters order by ts limit 5
select replace(nch1, nch2, 'nch2') from ts_4893.meters where position(nch2 IN nch1) != 0 order by ts limit 5
select replace(nch1, nch2, 'nch2') from ts_4893.meters where position(nch2 IN nch1) = 0 order by ts limit 5
select replace(nch1, var2, 'var2') from ts_4893.meters order by ts limit 5
select replace(nch1, var2, 'var2') from ts_4893.meters where position(var2 IN nch1) != 0 order by ts limit 5
select replace(nch1, var2, 'var2') from ts_4893.meters where position(var2 IN nch1) = 0 order by ts limit 5
select replace(nch1, '三', nch2) from ts_4893.meters order by ts limit 5
select replace(nch1, '三', nch2) from ts_4893.meters where position('三' IN nch1) != 0 order by ts limit 5
select replace(nch1, '三', nch2) from ts_4893.meters where position('三' IN nch1) = 0 order by ts limit 5
select replace(nch1, '三', var2) from ts_4893.meters order by ts limit 5
select replace(nch1, '三', var2) from ts_4893.meters where position('三' IN nch1) != 0 order by ts limit 5
select replace(nch1, '三', var2) from ts_4893.meters where position('三' IN nch1) = 0 order by ts limit 5
select replace(nch1, nch2, var2) from ts_4893.meters order by ts limit 5
select replace(nch1, nch2, var2) from ts_4893.meters where position(nch2 IN nch1) != 0 order by ts limit 5
select replace(nch1, nch2, var2) from ts_4893.meters where position(nch2 IN nch1) = 0 order by ts limit 5
select replace(nch1, var2, nch2) from ts_4893.meters order by ts limit 5
select replace(nch1, var2, nch2) from ts_4893.meters where position(var2 IN nch1) != 0 order by ts limit 5
select replace(nch1, var2, nch2) from ts_4893.meters where position(var2 IN nch1) = 0 order by ts limit 5
select replace(var1, 'a', 'b') from ts_4893.meters order by ts limit 5
select replace(var1, 'a', 'b') from ts_4893.meters where position('a' IN var1) != 0 order by ts limit 5
select replace(var1, 'a', 'b') from ts_4893.meters where position('a' IN var1) = 0 order by ts limit 5
select replace(var1, 'a', '啊') from ts_4893.meters order by ts limit 5
select replace(var1, 'a', '啊') from ts_4893.meters where position('a' IN var1) != 0 order by ts limit 5
select replace(var1, 'a', '啊') from ts_4893.meters where position('a' IN var1) = 0 order by ts limit 5
select replace(var1, '一', '壹') from ts_4893.meters order by ts limit 5
select replace(var1, '一', '壹') from ts_4893.meters where position('一' IN var1) != 0 order by ts limit 5
select replace(var1, '一', '壹') from ts_4893.meters where position('一' IN var1) = 0 order by ts limit 5
select replace(var1, '一', '1') from ts_4893.meters order by ts limit 5
select replace(var1, '一', '1') from ts_4893.meters where position('一' IN var1) != 0 order by ts limit 5
select replace(var1, '一', '1') from ts_4893.meters where position('一' IN var1) = 0 order by ts limit 5
select replace(var1, nch2, 'nch2') from ts_4893.meters order by ts limit 5
select replace(var1, nch2, 'nch2') from ts_4893.meters where position(nch2 IN var1) != 0 order by ts limit 5
select replace(var1, nch2, 'nch2') from ts_4893.meters where position(nch2 IN var1) = 0 order by ts limit 5
select replace(var1, var2, 'var2') from ts_4893.meters order by ts limit 5
select replace(var1, var2, 'var2') from ts_4893.meters where position(var2 IN var1) != 0 order by ts limit 5
select replace(var1, var2, 'var2') from ts_4893.meters where position(var2 IN var1) = 0 order by ts limit 5
select replace(var1, '三', nch2) from ts_4893.meters order by ts limit 5
select replace(var1, '三', nch2) from ts_4893.meters where position('三' IN var1) != 0 order by ts limit 5
select replace(var1, '三', nch2) from ts_4893.meters where position('三' IN var1) = 0 order by ts limit 5
select replace(var1, '三', var2) from ts_4893.meters order by ts limit 5
select replace(var1, '三', var2) from ts_4893.meters where position('三' IN var1) != 0 order by ts limit 5
select replace(var1, '三', var2) from ts_4893.meters where position('三' IN var1) = 0 order by ts limit 5
select replace(var1, nch2, var2) from ts_4893.meters order by ts limit 5
select replace(var1, nch2, var2) from ts_4893.meters where position(nch2 IN var1) != 0 order by ts limit 5
select replace(var1, nch2, var2) from ts_4893.meters where position(nch2 IN var1) = 0 order by ts limit 5
select replace(var1, var2, nch2) from ts_4893.meters order by ts limit 5
select replace(var1, var2, nch2) from ts_4893.meters where position(var2 IN var1) != 0 order by ts limit 5
select replace(var1, var2, nch2) from ts_4893.meters where position(var2 IN var1) = 0 order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', nch2, 'nch2') from ts_4893.meters order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', nch2, 'nch2') from ts_4893.meters where position(nch2 IN '一二三四五六七abcdefghijk213124123') != 0 order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', nch2, 'nch2') from ts_4893.meters where position(nch2 IN '一二三四五六七abcdefghijk213124123') = 0 order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', nch2, var2) from ts_4893.meters order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', nch2, var2) from ts_4893.meters where position(nch2 IN '一二三四五六七abcdefghijk213124123') != 0 order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', nch2, var2) from ts_4893.meters where position(nch2 IN '一二三四五六七abcdefghijk213124123') = 0 order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', var2, 'var2') from ts_4893.meters order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', var2, 'var2') from ts_4893.meters where position(var2 IN '一二三四五六七abcdefghijk213124123') != 0 order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', var2, 'var2') from ts_4893.meters where position(var2 IN '一二三四五六七abcdefghijk213124123') = 0 order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', var2, nch2) from ts_4893.meters order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', var2, nch2) from ts_4893.meters where position(var2 IN '一二三四五六七abcdefghijk213124123') != 0 order by ts limit 5
select replace('一二三四五六七abcdefghijk213124123', var2, nch2) from ts_4893.meters where position(var2 IN '一二三四五六七abcdefghijk213124123') = 0 order by ts limit 5
select replace('aabbccdd','aa', 'ee')
select replace('aabbccdd','AA', 'ee')
select replace('北京','北' , '南')
select replace('北京','京' , '南')
select replace('北京taos','北' , '南')
select replace(nch1, nch2, 't') from ts_4893.d0 order by ts limit 10
select replace(nch1, nch2, 't') from ts_4893.meters order by ts limit 10
select replace(nch1, var2, 't') from ts_4893.d0 order by ts limit 10
select replace(nch1, var2, 't') from ts_4893.meters order by ts limit 10
select replace(var1, nch2, 't') from ts_4893.d0 order by ts limit 10
select replace(var1, nch2, 't') from ts_4893.meters order by ts limit 10
select replace(var1, var2, 't') from ts_4893.d0 order by ts limit 10
select replace(var1, var2, 't') from ts_4893.meters order by ts limit 10
select replace(nch1, nch2, var1) from ts_4893.d0 order by ts limit 10
select replace(nch1, nch2, var1) from ts_4893.meters order by ts limit 10
select replace(null, 'aa', 'ee')
select replace(null, 'A', 'B')
select replace('', '', 'B')
select replace('', 'A', 'B')
select replace('A', 'A', '')
select replace('aabbccdd', null, 'ee')
select replace('Hello', 'Z', 'X')
select replace('Hello World', ' ', '_')
select replace('Hello World', 'World', 'MySQL')
select replace('12345', '5', 'five')
select replace('中国', '中', '国')
select replace('é', 'e', 'a')
select replace('!@#', '@', '#')
select replace('123456', '7', 'eight')
select replace(concat('A', 'B', 'C'), 'B', 'Z')
select replace(upper('abc'), 'A', 'X')
select replace(trim('  Hello  '), 'l', 'L')
select replace(lower('HELLO'), 'h', 'H')
select name, replace(substring(name, 1, 5), 'e', 'o') from ts_4893.meters limit 1
select name, replace(name, 'a', 'o') from ts_4893.meters limit 1
select var1, replace(var1, '1', 'one') from ts_4893.meters limit 1
select nch1, replace(nch1, 'n', 'm') from ts_4893.meters limit 1
