mariaDB中的列总和

What could be the best way to display only those rows where sum of scm,vd n quality is (e.g) greater than 20. all of them are int(4). And i am using PHP +mariaDB.

You can use simple query to get result:

SELECT * from table WHERE (scm+vd+quality ) >20;

WHERE (scm + vd + quality) > 20    -- The sum of the columns >20
  AND LEAST(scm, vd, quality) > 0  -- and none is zero