Mysql count with conditions
A simple tip on mysql query for multiple counts with conditions.
SELECT COUNT( * ) AS totalUsers, SUM( xu.state = “QLD” ) AS queenslandUsers FROM xxx_users AS xu
I’m a Software Engineer with 15+ years of experience building web and mobile applications, with a strong focus on property technology and business solutions. I work across frontend and backend development, while also contributing to technical architecture, product innovation, and solving complex engineering challenges. I’m particularly interested in AI-powered applications, real-time technologies, and creating simple, scalable solutions that deliver real value to users.
Latest posts by Kapildev J (see all)
- Travelling Salesman Problem using Branch and Bound Approach in PHP - July 5, 2016
- Javascript: Print content of particular div - March 4, 2015
- Group by with Order Desc in MySQL - June 3, 2014
Terms of Service | Privacy Policy | © 2002 - 2026 Srimax, India. All Rights Reserved.
