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 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/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
