Do i need to move output to a CSV file & then write a Java or C code for it.
I think a procedure can do it easily , If I know the proper function for
that.
Thanks
wal...@waltertross.com wrote:
What you want to do is not shuffle, but reverse the domain order, starting
from the TLD (top level domain). You may pick the string functions you
need from the string functions page of the manual, but the problem is that
there may be any number of subdomains, so that in principle you would need
a loop construct. If I were in your position, I wouldn't use MySQL to do
this.
ciao
Walter
Dear all,
I have million of sites stored in url column of a mysql table.
Some few examples are :-
www.facebook.com/home
adelaide.yourguide.com/news/local/news/entertainment/cd-review-day-and-age-the-killers/1401702.aspx
abclive.in/abclive_business/2393.html
abclive.in/abclive_business/assocham_manufacturing_companies.html
abclive.in/abclive_business/b-ramalinga-raju-satyam-financial-irregularities.html
aktualne.centrum.cz/report/krimi/clanek.phtml?id=635342
aktualne.centrum.cz/report/krimi/clanek.phtml?id=635306
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
in.abclive/abclive_business/2393.html
in.abclive/abclive_business/assocham_manufacturing_companies.html
in.abclive/abclive_business/b-ramalinga-raju-satyam-financial-irregularities.html
cz.centrum.aktualne/report/krimi/clanek.phtml?id=635306
cz.centrum.aktualne/report/krimi/clanek.phtml?id=635342
I need to shuffle the . words . Is there any in built function in mysql
to achieve this.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=wal...@waltertross.com
