select POSITION('北' IN '北京涛思')
select POSITION('涛思' IN '北京涛思')
select POSITION('a' IN 'abcd')
select POSITION('e' IN 'abcd')
select POSITION('好，' IN 'hello,world.你好，世界。')
select POSITION('，你' IN 'hello,world.你好，世界。')
select POSITION('world' IN 'hello,world.你好，世界。')
select POSITION('aaa' IN 'aaaaaaaaa')
select POSITION(CONCAT('a','b','c') IN CONCAT('abc','def','ghi'))
select POSITION(CONCAT('a','b','d') IN CONCAT('abc','def','ghi'))
select POSITION(nch2 IN nch1) from ts_4893.meters where POSITION(nch2 IN nch1) != 0 order by ts limit 5
select POSITION(nch2 IN nch1) from ts_4893.meters order by ts limit 5
select POSITION(var2 IN var1) from ts_4893.meters where POSITION(var2 IN var1) != 0 order by ts limit 5
select POSITION(var2 IN var1) from ts_4893.meters order by ts limit 5
select POSITION(var2 IN nch1) from ts_4893.meters where POSITION(var2 IN nch1) != 0 order by ts limit 5
select POSITION(var2 IN nch1) from ts_4893.meters order by ts limit 5
select POSITION(nch2 IN var1) from ts_4893.meters where POSITION(nch2 IN var1) != 0 order by ts limit 5
select POSITION(nch2 IN var1) from ts_4893.meters order by ts limit 5
select POSITION('a' IN nch1) from ts_4893.meters where POSITION('a' IN nch1) != 0 order by ts limit 5
select POSITION('a' IN var1) from ts_4893.meters where POSITION('a' IN var1) != 0 order by ts limit 5
select POSITION('一' IN nch1) from ts_4893.meters where POSITION('一' IN nch1) != 0 order by ts limit 5
select POSITION('一' IN var1) from ts_4893.meters where POSITION('一' IN var1) != 0 order by ts limit 5
select POSITION(nch2 IN 'abcdefghijklmn') from ts_4893.meters where POSITION(nch2 IN 'abcdefghijklmn') != 0 order by ts limit 5
select POSITION(var2 IN 'abcdefghijklmn') from ts_4893.meters where POSITION(var2 IN 'abcdefghijklmn') != 0 order by ts limit 5
select POSITION(nch2 IN '一二三四五六七八九十') from ts_4893.meters where POSITION(nch2 IN '一二三四五六七八九十') != 0 order by ts limit 5
select POSITION(var2 IN '一二三四五六七八九十') from ts_4893.meters where POSITION(var2 IN '一二三四五六七八九十') != 0 order by ts limit 5
select ABS(POSITION('aaa' IN 'aaaaaaaaa'))
select POW(POSITION('aaa' IN 'aaaaaaaaa'), 2)
select position('t' in 'taos')
select position('ustc' in 'taos')
select position('' in '')
select position('' in 'taos')
select position(nch2 in nch1) from ts_4893.d0 order by ts limit 10
select position(nch2 in nch1) from ts_4893.meters order by ts limit 10
select position(nch2 in var1) from ts_4893.d0 order by ts limit 10
select position(nch2 in var1) from ts_4893.meters order by ts limit 10
select position(var2 in nch1) from ts_4893.d0 order by ts limit 10
select position(var2 in nch1) from ts_4893.meters order by ts limit 10
select position(var2 in var1) from ts_4893.d0 order by ts limit 10
select position(var2 in var1) from ts_4893.meters order by ts limit 10
select position('t' in null)
select position(null in 'taos')
select position('' in 'A')
select position('A' in 'A')
select position('A' in '')
select position('A' in null)
select position('Z' in 'ABC')
select position('l' in 'Hello')
select position('s' in 'meters')
select position('中' in '中国')
select position('e' in 'é')
select position('W' in 'Hello World')
select position('@' in '!@#')
select position('6' in '12345')
select position('A' in trim(' A '))
select position('A' in upper('abc'))
select position('B' in concat('A', 'B'))
select position('x' in replace('Hello', 'l', 'x'))
select name, position('e' in name) from ts_4893.meters limit 1
select name, position('a' in substring(name, 2, 5)) from ts_4893.meters limit 1
select nch1, position('n' in nch1) from ts_4893.meters limit 1
select var1, position('1' in var1) from ts_4893.meters limit 1
