Is it possible to count two columns in the same query

by

In MySql, You can use the SUM() function over a condition, since a false condition will equal to 0, and a true one will equal to 1:

SELECT SUM(userID_follower = $myID) AS followerCount,
   SUM(userID_following = $myID) AS followingCount
FROM t1
WHERE userID_follower = $myID
   OR userID_following = $myID

More Related Contents:

  1. MySQL – Get row number on select
  2. Delimiters in MySQL
  3. MySQL query / clause execution order
  4. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  5. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  6. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  7. Operand Should Contain 1 Column – MySQL NOT IN
  8. How to convert timestamp to datetime in MySQL?
  9. MySQL varchar index length
  10. Best practices for SQL varchar column length [closed]
  11. How to design a multi tenant mysql database
  12. What are differences between INSERT and UPDATE in MySQL?
  13. MySQL dynamic cross tab
  14. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  15. How to disable index in innodb
  16. How to delete duplicate rows from a MySQL table
  17. mysql: why comparing a ‘string’ to 0 gives true?
  18. SQL query to check if a name begins and ends with a vowel
  19. What is the best way to store media files on a database?
  20. mySQL Error 1040: Too Many Connection
  21. base64 encode in MySQL
  22. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysql.sock’ (2)
  23. PID error on mysql.server start?
  24. remove all numeric characters from column mysql
  25. INNER JOIN Results from Select Statement using Doctrine QueryBuilder
  26. “Unknown column in ‘field list'”, but column does exist
  27. MySQL licensing and GPL [closed]
  28. Trouble with GROUP_CONCAT and Longtext in MySQL
  29. How to pass a variable to a IN clause?
  30. Insert and set value with max()+1 problems

Leave a Comment