repalce just start of string in sql

Vote count:

0

i have 3 column in my table:

+-+-+-+-+-+-+-+-+-+-+-++
+ ID + Name +   Cell   +
++++++++++++++++++++++++
+  1  +  FB + /moon/ta +
+  2  +  GO + /ta/ta   +
+  3  +  MO + /ta/mon  +
+  4  +  SS + /ta      +
+  4  +  SS + /ta/o/ta +
+-+-+-+-+-+-+-+-+-+-+-++

i want to replace all "/ta" with "/rr" in Cell Column that start of string, like:

+-+-+-+-+-+-+-+-+-+-+-++
+ ID + Name +   Cell   +
++++++++++++++++++++++++
+  1  +  FB + /moon/ta +
+  2  +  GO + /rr/ta   +
+  3  +  MO + /rr/mon  +
+  4  +  SS + /rr      +
+  4  +  SS + /rr/o/ta +
+-+-+-+-+-+-+-+-+-+-+-++

do you any idea for it?

asked 21 secs ago

MAND

1

repalce just start of string in sql