URL regex search and replace on MySQL (in WordPress)

I have a WordPress blog with numerous URL's I wish to replace开发者_如何学Go from this:

http://www.oldwebsite.co.il/name/***.asp

To this:

http://www.newwebsite.com/?p=***

For example, from this:

http://oldwebsite.co.il/name/65971.asp

To this:

http://www.newwebsite.com/?p=65971

I believe the following plugin: http://urbangiraffe.com/plugins/search-regex/ will do the trick with regex, but I am looking for the correct regex to use here.

I found this stackoverflow thread that has a similar task, but since I am not too apt with regex, I was hoping for help so I don't mess anything up.

Thanks,

Tal

Search for the regular expression:

http://oldwebsite\.co\.il/name/(\d+)\.asp

and replace with:

http://www.newwebsite.com/?p=$1

In PHP:

$after = preg_replace('%http://oldwebsite\.co\.il/name/(\d+)\.asp%', 'http://www.newwebsite.com/?p=$1', $before);