Mime-Version: 1.0 (Apple Message framework v623)
In-Reply-To: <1132269492.30942.20.camel@dev11dt.corp.localmatters.com>
References: <1132269492.30942.20.camel@dev11dt.corp.localmatters.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed
Message-Id: <5d001d303f001ea0847254c3f0a352d9@squeegeemedia.com>
Content-Transfer-Encoding: 7bit
From: Dawn Buie <dawn@squeegeemedia.com>
Subject: how to do a find and replace
Date: Thu, 17 Nov 2005 15:47:41 -0800
To: pgsql-sql@postgresql.org

Hello-
I'm using postgres 7.4

I have a column of data with the wrong prefix for many items.

The wrong entries are entered ' /0/v.myimage.jpg'
While the correct ones are ' /0/myimage.jpg'


I need to remove all the 'v.' characters from this column.


I'm able to do a

SELECT * FROM myTable
WHERE location = '%/0/v.%'


I'm just confused about how I should write code to update the selected 
items to remove the 'v.'

Would I use substring? An example would be much appreciated.

thank you
Dawn