2019独角兽企业重金招聘Python工程师标准>>>
eg:
select *
from (select *,substring_index(substring_index(remarks,"[",1),']',-1) as carCard from test ) as t
where carCard LIKE '%C999%'
转载于:https://my.oschina.net/iioschina/blog/1858614