Update Data in a row 1

[egmweb]

Hello All.

I have a database with 1400 rows and we have a column called descript. But each content of the row in "descript" have different text. This text have words with a "?" sign.

How can rename each word that have a ? sign with another word?

for example:

Descript >> hello we are t?king a lot...

We need to replace the word "t?king" of each row with "taking"

Thanks you in Advance.

 

[feherke]

Hi

update [green][i]table[/i][/green] set [green][i]field[/i][/green]=replace([green][i]field[/i][/green],[i]'t?king'[/i],[i]'taking'[/i]) where instr([green][i]field[/i][/green],[i]'t?king'[/i])!=0;

http://dev.mysql.com/doc/refman/4.1/en/string-functions.html

At least for what you wrote. But I think you want to do more [tt]update[/tt]s and want to do it with less commands. In that case you have to give us more detail.

Feherke.

http://rootshell.be/~feherke/

 

[egmweb]

Hey Feherke, Thanks you so much!!

Best Regards.

Eduard