title: How to update multiple rows of multiple columns with single value having same condition for every column
body: <p>I have a table having different type of Fees like security fees, tuition fees, admission fees etc and all of these column accept null values too.</p>
  
  <p>I want to update all null values of these columns with 0 value. I can write different update query for each column but because condition and value for all the columns is same I wanna learn to do it in a single update query.</p>
  
  <pre><code>Table_Fees
  securityFees | TuitionFees | AdmissionFees
   150            500             null
   null           450              120
   150            null             120         
  </code></pre>
  
  <p>How can I replace all null values with zero?</p>
  
  <pre><code>Update Table_Fees
   set securityFees = 0,
       TuitionFees  = 0,
       AdmissionFees = 0
  where securityFees = null 
  and   TuitionFees  = null
  and   AdmissionFees = null;
  </code></pre>
  
  <p>or/and both operator are not useful in this case</p>
  
  <p>PS: I can't change the structure of table. I can only replace null values with 0 through coding.</p>