Hi

I have a problem, after moving hosts my database for some reason failed to backup correctly

I have two columns lets call them col_b and col_c showing data of 0 in about 30% of the entries when they should be 1

These should be a value of 1 if col_a is also 1

what UPDATE command can i use in PHPmyadmin to change the entries in col_b and col_c if the value of col_a is 1?

Thanks John