update a specific word in column

Question

I have this column

column
London/paris
toronto/paris
Tokyo/paris

I want to update only the word 'paris'

My desirable result:

column
London/turkey
toronto/turkey
Tokyo/turkey

Can I have a condition like if next to paris is toronto I update it to berlin?

EDIT.
I want to know the queries in oracle or sybase. (I am not sure if I can ask this question separated in ora and syb, I hope a moderator give me an advice about that)

what if a row has something like `parish/bla`? – Jeffrey Kemp Jun 19 '13 at 05:09 — Jeffrey Kemp, Jun 19 '13 at 05:09

score 2 · Accepted Answer · answered Jun 17 '13 at 15:14

2

you can use the replace function for TSQL to do this

UPDATE myTable
SET MyColumn = REPLACE(MyColumn, 'paris', 'turkey')
WHERE MyColumn LIKE '%paris%'

answered Jun 17 '13 at 15:14

Hip Hip Array

4,665
11
49
80

TSQL is supported by Sybase-ASE so this should work on sybase – Hip Hip Array Jun 17 '13 at 15:22
Both Oracle and Sybase have a REPLACE() function. – APC Jun 17 '13 at 16:10

score 0 · Answer 2 · edited Jul 27 '13 at 11:17

0

Use:

update #t set col1 = str_replace(col1, 'paris', 'turkey')

edited Jul 27 '13 at 11:17

Ben

51,770
36
127
149

answered Jul 27 '13 at 10:45

deepak

141
2
9

This is almost identical to the earlier answer, but less efficient as you're going to update everything whether it needs it or not. – Ben Jul 27 '13 at 11:16

update a specific word in column

2 Answers2