----- Original Message -----
From: <kfoneil...@gmail.com>
To: "shawn wilson" <ag4ve...@gmail.com>
Sent: Thursday, July 14, 2011 1:28 AM
Subject: Re: How to Shuffle data
You could parse the URLs into different fields and save these to specific
fields (TLD, subdomain etc) in the database
which will then allow you to do an order by select to give the field order
you want.
I presume you could write a stored proc with string parsing for this in
MySQL.
If not you can read line by line in whatever your front end language is
(VisualStudio/Java whatever)
and parse the string into the components you want and save them back to
the database
You can then run a select on the table doing an order by on the fields you
want.
You can then loop through them, one by one, reconcatenate the fields to
the format you want and save the result to your output file.
I do not know mysql well enough to know if its string parsing and file
functions can do this, I am sure it wouldn't be too hard to do in C#,
Java, VB or whatever.
I really doubt that you will find any function anywhere that will do the
thing readymade and directly as you describe.
Split the URL at the first right slash, save the right fragment as it is,
chop of the end of the left fragment from the last dot and save the two
left fragments.
You can then recompose the URL in any form you want from the fragments: I
presume you will need to retain also the original form of the URL.
You can do an order by on fragment2, fragment1, fragment3 in your select
query.
It means at least two loops through the whole table, one to split the URLs
up and save them back to the table (or a second table as you wish), the
second to order the table and save the output to disk.
Kevin O'Neill
----- Original Message -----
From: "shawn wilson" <ag4ve...@gmail.com>
Cc: <mysql@lists.mysql.com>
Sent: Wednesday, July 13, 2011 11:18 PM
Subject: Re: How to Shuffle data
On Jul 13, 2011 6:41 AM, "Adarsh Sharma" <adarsh.sha...@orkash.com>
wrote:
Dear all,
I have million of sites stored in url column of a mysql table.
I need to shuffle the . words . Is there any in built function in mysql
to
achieve this.
Why would you want to do this in mysql? What's your programming language
of
choice? Do you have a favorite db api and csv library for that language?
Then its just something like:
(+\.^\.){3}(/*$)
And do something with them. (warning, I just attempted at regex on a
phone)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
