Simple Mysql Query Help

On my site i have rapidshare.com links in my posts. Some of posts has more than one rapidshare link so wihch one query i want to list all rapidshare urls.

How can i do it ?
I tried this but i couldn't be successfull

 SELECT *
FROM `my_blog`.`wp_posts`
WHERE ID REGEXP '[[:<:]]http://rapidshare[[:>:]]'

Code (markup):

 

SELECT *
FROM `my_blog`.`wp_posts`
WHERE `ID` LIKE '%http://rapidshare%'

Code (markup):

Insure ID field is fulltext.

Why is ID being searched? Shouldn't it post/text/body?

Peace,

 

This is right one but i want to grab that rapidshare links like a list
example
rapidshare.com/sdfsf
rapidshare.com/sdfsdf

SELECT * FROM `wp_posts` WHERE post_content LIKE '%http://rapidshare%'

PHP:

 

whether you want to grab list of rapidshare links from a wordpress post ?

If your answer is yes,then it is difficult to do so via SQL

you can simply parse out the urls using a php script