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:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 2: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]
