Replace one word with another in lots of rows in a database
Posted: Thu Mar 27, 2008 5:22 am
Hello,
Is there in any way (with MySQL or PHP or software) to replace one work with another in all rows in a table?
I have about 7000 product descriptions in Swedish and I need to translate them into English. The good thing is that all the description only contain a few words (I think that I just need to replace about 30 words in total to translate everything). The bad thing is that I don't know how to do that.
So I want to select all rows with the language id for English (currently all English decriptions are in Swedish) and then replace all occurances of a specific word with another specific word.
So UDPATE description ???? WHERE language_id = 5 is what I've figured wold be a start for an MySQL command... the problem is that I don't know what to put instead of ????.
Would it be possible to do that in PHP or MySQL? Could you help me with any kind of command (is that how you say it?) or any other help?
Regards /Oskar
Is there in any way (with MySQL or PHP or software) to replace one work with another in all rows in a table?
I have about 7000 product descriptions in Swedish and I need to translate them into English. The good thing is that all the description only contain a few words (I think that I just need to replace about 30 words in total to translate everything). The bad thing is that I don't know how to do that.
So I want to select all rows with the language id for English (currently all English decriptions are in Swedish) and then replace all occurances of a specific word with another specific word.
So UDPATE description ???? WHERE language_id = 5 is what I've figured wold be a start for an MySQL command... the problem is that I don't know what to put instead of ????.
Would it be possible to do that in PHP or MySQL? Could you help me with any kind of command (is that how you say it?) or any other help?
Regards /Oskar