SQL截取字符串的某一段

请用SQL，截取网站中的“ie=UTF-8&wd”

比如这个链接：
https://www.baidu.com/s?ie=UTF-8&wd=%EF%BD%86%EF%BD%85%EF%BD%89%EF%BD%93%EF%BD%88%EF%BD%95&tn=85070231_hao_pg

需要截取，ie=UTF-8&wd

解决办法：

SELECT
	substring_index( a.abstract, '=%', 1 ) AS jiequ 
FROM
	( SELECT substring_index( 'https://www.baidu.com/s?ie=UTF-8&wd=%EF%BD%86%EF%BD%85%EF%BD%89%EF%BD%93%EF%BD%88%EF%BD%95&tn=85070231_hao_pg', 's?',- 1 ) AS abstract ) a

显示结果

第二种方法：

SELECT SUBSTRING('https://www.baidu.com/s?ie=UTF-8&wd=%EF%BD%86%EF%BD%85%EF%BD%89%EF%BD%93%EF%BD%88%EF%BD%95&tn=85070231_hao_pg',25,11) as jiequ

显示结果: