6 messages in com.mysql.lists.mysqlRE: Regular expresion replace possibi...
FromSent OnAttachments
Dean Householder21 Jul 2003 13:48 
Mike Hillyer21 Jul 2003 13:53 
Dean Householder21 Jul 2003 14:38 
Mike Hillyer21 Jul 2003 14:41 
Jennifer Goodie21 Jul 2003 15:50 
Terry Spencer22 Jul 2003 03:13 
Subject:RE: Regular expresion replace possibility?
From:Mike Hillyer (mhil@rinax.com)
Date:07/21/2003 01:53:34 PM
List:com.mysql.lists.mysql

UPDATE mytable SET mytext = REPLACE(mytext,'"','');

Assuming you wised to strip a double quote, modify to suit.

Regards, Mike Hillyer www.vbmysql.com

-----Original Message----- From: Dean Householder [mailto:dh@adoption.com] Sent: Monday, July 21, 2003 2:49 PM To: mys@lists.mysql.com 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