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.
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.