select remarks
from (select *,substring_index(substring_index(remarks,"】",1),'【',-1) as carCard from p_record_event ) as acc
where carCard LIKE '%C999%'select remarks
from (select *,substring_index(substring_index(remarks,"】",1),'【',-1) as carCard from p_record_event ) as acc
where carCard LIKE '%C999%'