|Subject||Re: [firebird-support] Replacing substrings...|
Sergio H. Gonzalez wrote:
>> update changeme set field01 = replace(field01, 'Fpdd', '<newvalue>')Performance would be the same or slightly worsse, I think. All records have to be scanned anyway; if you add the WHERE clause, the contents of matching records will be scanned twice: once by POSITION, and then once by REPLACE.
> ...and if the table has a lot of records, probably adding
> where position ('Fpdd' in field01)> 0
> would help... or it's the same, regarding performance?