php - mysql中的cae when 批量更新

Question

Answer 1

应该是忘了加引号了吧？

sprintf(' WHEN \'%s\' THEN \'%s\'', $v['open_id'], $v['unionid']);