Change a portion of a field

[szaunbr]

I am new to the postgresql "game". I am trying to clean up some data in my database, mainly addresses. What I would like to do is change every instance of 'First' to '1st' in the address field.

Ex: '325 West First St' to
'325 West 1st St'

Is it possible to update just a portion of a field??

Any guidance would be greatly appreciated.

 

[feherke]

Hi

[tt]replace()[/tt] ?

[blue]db=#[/blue] [b]select[/b] address [b]from[/b] szaunbr;
      address
-------------------
 325 West First St
(1 row)

[blue]db=#[/blue] [highlight #eee][b]update[/b] szaunbr [b]set[/b] address=replace(address,[i]'First'[/i],[i]'1st'[/i]);[/highlight]
UPDATE 1

[blue]db=#[/blue] [b]select[/b] address [b]from[/b] szaunbr;
     address
-----------------
 325 West 1st St
(1 row)

http://postgresql.org/docs/8.1/interactive/functions-string.html

Feherke.

http://rootshell.be/~feherke/