I suck at regexp! (read: HELP!)

[Cloudrunner]

So I need a little guidance.

This is for my latest idea for a hack and will be released soon.

BUT

I have setup the sql to pull all the posts from the DB that contain a URL link via

SELECT pagetext FROM posts WHERE pagetext LIKE '%[ URL ]%[ /URL ]%';

That being the case then $row['pagetext'] will be the entire post.

From that string I need to extract each and EVERY instance of '[ URL ]blah[ /URL ]' from within that string.

Now I understand I could use the explode(); function etc, but that only gives the first instance of '[ URL ]blah[ /URL ]'. I need each and every instance because my users have a habit of adding multiple URLs to their posts.

That being said, anyone who can lend a hand on this will get full credit when the hack is released.

Any takers, or even suggestions?

I've been fighting this for a few days to get the correct way to do it, and have been found a failure at it, for I suck at regexp!

Thank you in advance for any help that you may give.

)O( Cloudrunner )O(