>From the manual:
REPLACE(str,from_str,to_str)
Returns the string str with all occurrences of the string from_str replaced
by
the string to_str:
mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
-> 'WwWwWw.mysql.com'
This function is multi-byte safe.
Terry Spencer
Haigh Consultancy Services
+44 (0)2073007329
www.haigh-cs.co.uk
-----Original Message-----
From: Dean Householder [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 9:49 PM
To: [EMAIL PROTECTED]
Subject: Regular expresion replace possibility?
Is it possible to run a query that will just alter text possibly using a
regular expression? I have about 250 rows that I want to strip quotes
out of. Does anyone know of an easy way to do this?
Dean
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
