replace

[scialom]

Hi,

I have a table with a lot of word. I need to translate all the words to other language. I want to translate once per word and than replace all of the same in the db.

for ex:
if I translate the word "color" to "colour" I want that the script will replace it all over the fields.

my db look like this:

row 1: field 1 field 2
Flower Power color,base,run...

row 2: Flower Power happy,love, color...

What is the best way to do it?
Assaf