mysql判断是否包含某字符串的5种方式:速度最快的是locate

SELECT * FROM outbox where sn_list like '%T20000001000021%' limit 1
SELECT * FROM outbox where FIND_IN_SET("T20000001000021",sn_list) limit 1
SELECT * FROM outbox where locate("T20000001000021",sn_list) limit 1
SELECT * FROM outbox where POSITION("T20000001000021" IN sn_list) limit 1
SELECT * FROM outbox where INSTR(sn_list,"T20000001000021") limit 1