Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

[Jay Sprenkle]

On 8/8/06, Olaf Beckman Lapré <[EMAIL PROTECTED]> wrote:

How would this compare to the performance of simply (progammatically) doing
an UPDATE and changing the values in a callback hook. If this is impossbile
than even a SELECT with a callback where one does an UPDATE  for each
returned row would be possible.

If this was a task that needed to be done many times I would create a program
to do it. If it is a one time fix the manual solution suggested would
be quicker.
Sed/ed/awk/vi/elm work very well if you know how to use them.

You might also try to write a user defined function that edits your
text as desired.
Then you can simply use one update statement:

UPDATE myTable SET MyField = MyFunction( MyField );