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)