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