You can do this: update table set colum="/realtors/This_Value/" where colum="/realtors/Value/";
But, it´ll replace all records at once. "Ed Curtis" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > > I have a column in a table I need to replace a value of certain records > in. The current value is /realtors/Value/. I need to change them to > /realtors/This_Value/. Is there an easy way to do this. There are way too > many records to do it one record at a time. > > Thanks, > > Ed > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]