In infinite wisdom Adarsh Sharma <adarsh.sha...@orkash.com> 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> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
