get the website from the user profile in MDN

get_website_from_profile.sql

select substring(
	misc
	from (
		/* start substring after but not including website key */
		locate('"website": ', misc) + 12
	)
	for (
		/* the location of the first " after the website key... */
		locate('"', misc, locate('"website": ', misc) + 12) 
		/* minus the location of the website key plus the length of the website key */
		- (locate('"website": ', misc) + 12)
	)
)
as url from user_profiles 
where misc is not null 
and misc REGEXP'"website": ';