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 tablename SET column='/realtors/This_Value/' WHERE
column='/realtors/Value/';
Should do the trick.
Cory
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
