PrisonPants PrisonPants - 1 month ago 10
SQL Question

Total number of some rows of a special record

I wrote this:

SELECT * FROM `playerdetails` WHERE `power` + `violence` + `shooting` >= '50' LIMIT 1


I want the correct way.

Answer
SELECT * FROM `playerdetails` WHERE (`power` + `violence` + `shooting`) >= '50' LIMIT 1