On Jul 13, 2011 6:41 AM, "Adarsh Sharma" <[email protected]> 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)