sql利用正则从字符串中抽取字段

select  t2u(regexp_extract(event_args['refer'],'(.*?)(token=)(.*)',3)) 
from event 
where date between   '2016-06-22' and '2016-06-23' 
and event_name = 'web.act.crush.home.view'