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…