URL regex search and replace on MySQL (in WordPress)

I have a WordPress blog with numerous URL’s I wish to replace from this:

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

Read More

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

Related posts

Leave a Reply

1 comment

  1. 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);