update table set field=REPLACE(field, 'vhs', 'dvd'); "Gabriel Mahiques" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > Hello friends. > In need your help. > I have a table with a field "Name: Varchar(255)". > In this field "Name" I have a detail and I need replace in all records a > word for another. > For example: I have "vhs" and I want to change the word "vhs" for the word > "dvd" in all records. > How can I do this? > -- > Saludos cordiales. > ------------------------------------------------------------------------ > Ing. Gabriel Mahiques > Dto. Control de Gestión > ELECTROINGENIERA S.A. > Telefono: 474 1414 > Uspallata 1461. Barrio San Martín. CP: X5008HSH > Córdoba. República Argentina.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]