DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
mysql count with if
SELECT COUNT(IF( `column` = 1, `column`, NULL)) as total
Source by modern-sql.com #
PREVIOUS
NEXT
Tagged:
#mysql
#count
ADD COMMENT
Topic
COMMENT
Name
8+9 =
Submit