title: Total number of yes and no values from mysql database table row
body: <p>I have a mysql table with 48 columns. The values in the table will be either "yes" or "no". I want to get the number of yes's and no's from a row.</p>
  
  <p>For example:</p>
  
  <p>One row having 23 Yes's and 25 No's, then it should display the total count at the front end
  <img src="https://i.stack.imgur.com/s9cBl.png" alt="enter image description here"></p>