> I've xml contents in a column of one table. Inside that xml content, I've > sometime an hardcoded link which I needs to change automatically (lets > say: > from host.domain.com/dev to host2.domain.com) > > I'm searching how to build the sql statement to do it but I don't > understand > how to do this manipulation.
You can for example use the replace function: UPDATE table1 SET col1 = REPLACE(col1, 'host.domain.com/dev', 'host2.domain.com') WHERE .... http://dev.mysql.com/doc/mysql/en/String_functions.html Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
