List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:August 23 2005 7:24pm
Subject:RE: SQL help
View as plain text  
[snip]
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 ?
[/snip]

http://dev.mysql.com/doc/mysql/en/string-functions.html the manual is
your friend

UPDATE item SET item = REPLACE(item, '"', '')
Thread
SQL helpDarryl Hoar23 Aug
  • Re: SQL helpPeter Brawley23 Aug
RE: SQL helpJay Blanchard23 Aug