How about something like....

Code
UPDATE w3t_Posts
SET B_Body = '%[url=http://%]http://%[/url]%
WHERE B_Body LIKE '%http://%'

<img src="https://www.ubbcentral.com/boards/images/graemlins/grin.gif" alt="" />

*do not try this at home*

Visit the real Threadsdev at http://www.threadsdev.net