Worked like a charm! I couldn't find anything about this in MySQL docs though... Neither before I knew what to search for nor after. What's up with that?
Dean ----- Original Message ----- From: "Mike Hillyer" <[EMAIL PROTECTED]> To: "Dean Householder" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 1:53 PM Subject: RE: Regular expresion replace possibility? 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]