find_in_set,locate,instr

select find_in_set('3','2,3,4,5,1');
返回 2

select locate('3','2,3,4,5,1');
返回3

select instr('2,3,4,5,1','3')
返回3

 

posted @ 2022-04-07 13:55  天妖姥爷  阅读(34)  评论(0编辑  收藏  举报