Re: Replacing A Value

2006-06-01 Thread jonathan
by 'value', you mean variable, right? is it a filepath? On Jun 1, 2006, at 9:17 AM, Cory wrote: Ed Curtis wrote: 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

Re: Replacing A Value

2006-06-01 Thread Cory
Ed Curtis wrote: 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 UPDATE

Re: Replacing A Value

2006-06-01 Thread Adrian Bruce
UPDATE Query Tip No. 1: Manuals, Google etc Tip No. 2: Posting a question like this may result in sarcastic responses and possibly mass flaming Ed Curtis wrote: 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 ch

Re: Replacing A Value

2006-06-01 Thread Jo�o C�ndido de Souza Neto
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

Re: Replacing A Value

2006-06-01 Thread Duncan Hill
On Thursday 01 June 2006 17:02, Ed Curtis wrote: > 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 http://dev.mysql.com/doc/refm

Replacing A Value

2006-06-01 Thread Ed Curtis
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 Mailin