Try : (on a test table first of course)
UPDATE prodtable SET ProKeywords = REPLACE(ProdID, '-', '');
You may want to look at this page: http://www.mysql.com/doc/en/String_functions.html
jeff
At 11:57 -0600 3/3/03, Doug Coning wrote:
Hi all,
I want to take the data in a column, modify and then set it into another column. In specific, I want to remove the dash from our Product ID column and place it in another column without the dash.
For instance, a ProdID may be 'SK-22'. I want to take this value from ProdID and place it as 'SK22' into ProdKeywords column for the same record.
How would I go about removing the '-' and placing the remainder in the ProdKeywords column.
Thank you,
Doug Coning sql,query,queries,smallint
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Jeff Shapiro, Colorado Springs, CO, USA
At work I *have* to use a Windows machine, at home I *get* to use a Mac.
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
