Remapping Wordpress URLs using routes, not htaccess

[eluser]Daniel H[/eluser]
Hi all,

I'm about to migrate a site from wordpress to a bespoke system. I have migrated the wordpress articles almost field for field to the new system, so that the url title remains the same.

So, what I'd like to do programmatically (i.e. not using htaccess) is to take this url:

http://www.mysite.com/2008/11/26/some-url-title/

and map it to

http://www.mysite.com/blog/post/23/some-url-title/

by way of having a route which specified if the URL of the latter type is found, map it to a controller/function called blog/wordpress. The wordpress function will then query the db using url-title, and redirect to the correct post.

However routes really confuse me and I'm not sure what the best way to do this is - please can someone suggest how to do this?

Thanks,
Dan.