How can I move the contents of a column in a MySQL table to a second column in the same table (and set the old column to '') based on certain criterea?
Thanks!
Chris Bloom
If anyone was curiour here's the deal:
UPDATE table SET column2 = column1, column1 = '' WHERE column3 = 'x'
There's better info at: http://www.mysql.com/doc/U/P/UPDATE.html
