题解 | #最后一个匹配上的位置#

-- 方法1

select device_id,

locate('abc',nick_name) last_idx,

substring(nick_name,locate('abc',nick_name)) check_str

from user_submit

where nick_name like '%abc%'

ORDER BY device_id DESC;

-- 方法2

select device_id,

instr(nick_name,'abc') last_idx,

substring(nick_name,instr(nick_name,'abc')) check_str

from user_submit

where nick_name like '%abc%'

ORDER BY device_id DESC;

-- 方法3

select device_id,

position('abc' in nick_name) last_idx,

substring(nick_name,position('abc' in nick_name)) check_str

from user_submit

where nick_name like '%abc%'

ORDER BY device_id DESC;