CODEWITHSUNDEEP
mysqlphpmyadmin
HockeyFL954
HockeyFL954

Reputation: 11

Copying one column to another column in the same table for product listings

I read some other posts on here but wasnt sure if it completely related to my issue. I need to copy a column called "Title" to another column called "Keywords" within the same table. It is for a classified listing site that has unique sid's, category_sid's and user_sid's, etc..per row.

What would the query be for this? I just want to make sure that nothing else will be affected and that only the Keywords column updates to match the data in the Title column.

Thanks!

Upvotes: 0

Views: 116

Answers (1)

Andreas Wederbrand
Andreas Wederbrand

Reputation: 39971

Just update all rows setting the value of Keywords to the value of Title.

update your_table set keywords = title;

Upvotes: 2

Related Questions