score:2

You can filter with the where-clause

UPDATE myTable
SET *name = REPLACE(*name, 'Tulipa', 'Tulipes')
WHERE *name like 'Tulipa%'

*name = your columnname

score:2

select * from <myTable> where [name(1)] like 'Tulipes%'


Name             Country Name(1)
Tulipa Apeldoorn FRA     Tulipes Apeldoorn
Tulipa Abba      FRA     Tulipes Abba


update <myTable> set [name(1)]='your text'  where [name(1)] like 'Tulipes%'

More questions

More questions with similar tag