Mysql DB move 1 column (w/ data) from one table to another seamlessly?

[eluser]Devon Lambert[/eluser]
[quote author="drewbee" date="1221764534"]Not sure if you have what you need, but just so you konw you can do a subquery from an insert as well. IE

INSERT INTO new_table (col1, col2, col3) VALUES (SELECT col1, col2, col3 FROM old_table)


PS. Corn jobs are the best! [/quote]

Haha, yes gotta love those Corn jobs. :-)

Thanks to everyone for this advice.

Definitely what I was looking for. I believe your way may work best Drewbee as it is the most straightforward. I'll give it a go later today and let you all know how it went.

Thanks again.