In infinite wisdom Adarsh Sharma <adarsh.sharma@stripped> wrote:
> Dear all,
>
> I have million of sites stored in url column of a mysql table.
>
> Some few examples are :-
>
> www.facebook.com/home
> I want to take the output in a tsv file the sites url in the below forms :
>
> com.faebook.com/home
>
> com.yourguide.adelaide/news/local/news/entertainment/cd-review-day-and-age-the-killers/1401702.aspx
> I need to shuffle the . words . Is there any in built function in mysql
> to achieve this.
Dealing with urls is a non trivial problem. Have a look at google-url
library <http://code.google.com/p/google-url/> for a robust solution.
--
Raj Shekhar
-
Tonight at 11 - DOOM!
-
Read the latest at my blog: "a bag of tips"
<http://rajshekhar.net/blog/archives/408-a-bag-of-tips.html>
