From: Peter Brawley Date: August 23 2005 8:33pm Subject: Re: SQL help List-Archive: http://lists.mysql.com/mysql/188197 Message-Id: <430B882A.5050004@earthlink.net> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=======AVGMAIL-430B882D38B3=======" --=======AVGMAIL-430B882D38B3======= Content-Type: multipart/alternative; boundary=------------040302060903070601030802 --------------040302060903070601030802 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Darryl, />Unfortunately the item field has got data with quotes around it. IE >"KP-00310". I need to clean up the data and have the field contain >just KP-00310. Since I have 10,000 records, I need a update >statement or something to clean that up./ To remove all double quotes: UPDATE tablename SET item=REPLACE(item,'"',''); PB ----- Darryl Hoar wrote: >Greetings, >I have a table in my database called item. It has two fields: item and >description. > >Unfortunately the item field has got data with quotes around it. IE >"KP-00310". I >need to clean up the data and have the field contain just KP-00310. Since I >have >10,000 records, I need a update statement or something to clean that up. > >Any ideas ? > >thanks, >Darryl > > > > > --------------040302060903070601030802 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Darryl,

>Unfortunately the item field has got data with quotes around it. IE
>"KP-00310". I need to clean up the data and have the field contain
>just KP-00310. Since I have 10,000 records, I need a update
>statement or something to clean that up.

To remove all double quotes: UPDATE tablename SET item=REPLACE(item,'"','');

PB

-----

Darryl Hoar wrote:

Greetings,
I have a table in my database called item.  It has two fields: item and
description.

Unfortunately the item field has got data with quotes around it. IE
"KP-00310".  I
need to clean up the data and have the field contain just KP-00310.  Since I
have
10,000 records, I need a update statement or something to clean that up.

Any ideas ?

thanks,
Darryl

--------------040302060903070601030802-- --=======AVGMAIL-430B882D38B3======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.14/79 - Release Date: 8/22/2005 --=======AVGMAIL-430B882D38B3=======--