Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Egor Shevtsov (nixofortunegooglemail.com)
Date: Thu Jul 08 2010 - 14:37:56 CDT
I wonder if possible at all to use replace() together with regex in
I want to be able to update a field of string values and replace a
'dash' character with a space in the string.
UPDATE table SET column = replace(column, regex '%-%', ' ') where id = xxx;
Obviously, regex doesn't work inside of replace().
Any suggestions, guys?
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql