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/refman/5.0/en/update.html Applies to 4.1 too. Search for replace, the relevant entry is in the user comments. (You don't want the REPLACE SQL command, but the replace argument for SELECT). ---- Scanned by mailCritical. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
