eg:
select *
from (select *,substring_index(substring_index(remarks,"[",1),']',-1) as carCard from test ) as t
where carCard LIKE '%C999%'
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