instr函数 mysql_mysql数据库中查找字串出现的位置instr函数

在chengshi表中增加数据：

insert into `chengshi` (`id`, `shengfen`, `chengshi`) values('1','河南','安阳');

insert into `chengshi` (`id`, `shengfen`, `chengshi`) values('2','河南','郑州');

insert into `chengshi` (`id`, `shengfen`, `chengshi`) values('3','河南','洛阳');

insert into `chengshi` (`id`, `shengfen`, `chengshi`) values('4','河南','漯河');

insert into `chengshi` (`id`, `shengfen`, `chengshi`) values('5','河南','新乡');

insert into `chengshi` (`id`, `shengfen`, `chengshi`) values('6','河南','濮阳');

insert into `chengshi` (`id`, `shengfen`, `chengshi`) values('7','河南','焦作');

insert into `chengshi` (`id`, `shengfen`, `chengshi`) values('8','河南','鹤壁');

insert into `chengshi` (`id`, `shengfen`, `chengshi`) values('9','河南','开封');