Remove "-"?

d 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 --

Is this possible?

hout having to use a temporary table... Thanks, Doug Coning - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-

Re: Is this possible?

- Original Message - From: <[EMAIL PROTECTED]> To: "Doug Coning" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 9:15 AM Subject: Re: Is this possible? > Your message cannot be posted because it appears to be either spam or > simply off topic to our filt

Group By

ow would I modify this query to return all the items from Category, Category2, Category3, Category4 and Category5 and then group them all by similarities? Thank you, Doug Coning - Before posting, please check: http://www

Copy Records in a table...

Hi everyone, I'm still learning MySQL. I have a database of 600 items. I am still adding products. Several of these products are identical in nature, but have maybe one or two columns that are different. Is there a way to write a SQL command that selects these items and then inserts them, and

Re: Newby: Duplicate Records in table...

Hi everyone, How do I select a group of records in a table and automatically duplicate them into the same table while modifying 1 or 2 columns without having to re-insert each record individually? Thanks, Doug MySQL - B

Newbie: How do I copy over a new database?

directory. Please advise. Thanks in advance! Doug Coning - 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