Mysql Clause Help

Hi,
i have a DB structure like this;
[code]
id INT[11] (PK)
address VARCHAR[50]
[/code]

and in address column i have some addresses in this structure.

“SOMEWORD1(s) [SPACE] SOMEWORD2(s) [. – ] SOMEWORD3(s)”

what i need i want a SQL clause from you and it will change the address field like this

“SOMEWORD3(s) [SPACE] SOMEWORD1(s) [SPACE] SOMEWORD2(s)[.] ”

Again, i want it as a SQL Clause or Bash script that i can execute it from terminal window.

Note: Server is Ubuntu 10.x,
Note2: That table is very big about 13 million rows and file size about 17 GB…

Leave a Reply

Your email address will not be published. Required fields are marked *