Gossamer Forum
Home : Products : Others : MySQLMan :

replace strings

Quote Reply
replace strings

Maybe this post is not strictly related to MySQL MAN, I try anyway.
With an update query I can substitute values in a table.

For instance replace in the field Name Bob by Robert. OK
Update table set Name = 'Robert' where' Name = 'Bob'

What I would like to do is to have the same thing done in a larger way
For instance 'Bob Dylan' trasformed in 'Robert Dylan'
and 'Bob Marley' trasformed in 'Robert Marley'

Is it possible to do it directly my Mysql?

Thanks for your answers