Hello!

Is there a way to replace specific text fragment (string) with another one in all fields of a table by an SQL query?

Thanks!
Janis

Do you want that to be done for a column on all rows or for all columns in all rows? Can you explain that in detail?

_________________________
- Vijay G
Strive for Perfection

For one (text type) column on all rows.

Janis

Check the MySql documentation for, if that supports REPLACE() function, if so you can do that easily. Else, will have to look for other way round.

_________________________
- Vijay G
Strive for Perfection

Thanks! It really worked, when I found that function.

Before that I searched for "replace" in the documentation, but found that replace is an operation like insert, only it replaces the rows in case of a duplicate key or something like that. And I didn't even search more to find out that there is such a function replace(). :)

So, I successfully managed to replace text with this kind of query:

update tableName
set fieldName=replace(fieldName,"oldString","newString")

Thanks,
Janis

Yes, Glad that it worked. I was sure about Replace function's existence in MS Sql Server, though I haven't really used that in MySql/need didn't arise yet. That's why I suggested to check if MySql supports that function.

Cheers!

_________________________
- Vijay G
Strive for Perfection