求正则表达式

[qq_28377393]

用正则表达式提取特定字符之间以bd开头的字符串，特定字符有#，&，##，$，=,?

例如
http://baidu.efbdji.net/120.html?a_shfghdjy={madfafgpe}&a_adffdgn={adpsafagion}#bd1ahGDDFjf546a$bd1hjhTfCH56

得出结果 bd1ahGDDFjf546a,bd1hjhTfCH56

[天际的海浪]

var str = "http://baidu.efbdji.net/120.html?a_shfghdjy={madfafgpe}&a_adffdgn={adpsafagion}#bd1ahGDDFjf546a$bd1hjhTfCH56";
var arr = str.match(/[#&=\$\?]bd[^#&=\$\?]+/ig);
for(var i = 0, len = arr.length; i < len; i++){
	arr[i] = arr[i].slice(1);
}
alert(arr);

[qq_28377393]

非常感谢，请问能在数据库函数中使用吗，下面是我再数据库中建的函数

Create FUNCTION [dbo].[Regex.Match](@Regex [nvarchar](max), @Input [nvarchar](max))
RETURNS [nvarchar](max) WITH EXECUTE AS CALLER
AS 
EXTERNAL NAME [Regex].[MSSQLRegexExtend.RegexExtend].[Match]