mysql,如何用sql语句实现,用正则匹配url字段里的数字id,然后存入另一个字段
CREATE TABLE `testvarchar` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`urlId` int(10) unsigned NOT NULL DEFAULT '0',
`url` varchar(1000) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
insert into testvarchar (url) values ('https://www.abc.com/xxx/22277598?preview_for_ml=true'),('https://www.abced.jp/xxx/13008554'),('http://cd.qwer.com/asdf/17996991703.html'),('https://www.asd.com/zxc/ical/21853688.ics?s=92503680b6e4692f6a364503048bb964');
现在urlId字段需要得到对应的url里的数字id
分别是22277598,13008554,17996991703,21853688
请问怎么用sql实现?