UPDATE xt_d_answerdata SET q19='是' WHERE Q12='是'OR q15='是'
UPDATE xt_d_answerdata SET q19='否' WHERE Q12='否'AND q15='否'
SELECT q21,COUNT(*) FROM xt_d_answerdata GROUP BY q21
UPDATE xt_d_answerdata SET q20='是' WHERE q21='網點信息相符'
UPDATE xt_d_answerdata SET q20='否' WHERE q21<>'網點信息相符' AND q21 IS NOT NULL AND q21<>''
UPDATE xt_d_answerdata SET q23='是' WHERE q21='網點信息相符'
UPDATE xt_d_answerdata SET q23='否' WHERE q21<>'網點信息相符' AND q21 IS NOT NULL AND q21<>''