I need to replace part of a string in a field with another piece of string.
Look I know it is wrong:
- In this case I didn't specified the field, but that's what I want to.
- In the example below, I think it is going to consider the whole table
UPDATE test SET REPLACE('/','/','#') WHERE description LIKE '%/%'
I need a help to construct a correct update taking in consideration an option to choose a field for replacement.
thanks
Look I know it is wrong:
- In this case I didn't specified the field, but that's what I want to.
- In the example below, I think it is going to consider the whole table
UPDATE test SET REPLACE('/','/','#') WHERE description LIKE '%/%'
I need a help to construct a correct update taking in consideration an option to choose a field for replacement.
thanks