update

[kotturusunil]

Hello,

I am trying to update my table like,set the column value of '5' to column '6'
where column '6' is empty.. But when i try the following query "UPDATE `qb_question`
SET `qb_question_correctoption`=`qb_question_option5`
WHERE `qb_question_correctoption`=''".. remaining fields getting effected like they went empty..

please help me,

Thanks in advance

[bdl]

Please post the entire SQL statement, formatted properly in CODE tags, and any error statements or warnings issued.