msyql 截取字段中指定值

select SUBSTRING_INDEX(abc,";",-1) as http_user_agent from (SELECT SUBSTRING_INDEX(http_user_agent,"/",2) as abc  FROM `ip_limit_20140903` WHERE http_user_agent LIKE "%Android%" AND http_user_agent REGEXP ' ' LIMIT 0,100) as aaa;