At 10:55 AM +0100 11/14/99, Søren Merser wrote:
>I wanna go through my database, searching a char(250) field for any
>occurences of the letter combination 'Ps' and do a replace to ' F', leaving
>the text otherwice untouched.
>How do I write a SQL statement? or do I need to do some C/perl/awk script to
>do the job? or can I pass the database file itself through awk/sed using a
I'd probably use UPDATE and the REPLACE() function:
SET col_name = REPLACE (col_name, 'Ps', ' F')
WHERE col_name LIKE '%Ps%'
The WHERE clause isn't strictly necessary, actually.
Paul DuBois, paul@stripped
|• replace text?||Søren Merser||14 Nov|
| • Re: replace text?||Paul DuBois||14 Nov|