: IF : Control Flow Functions MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
Control Flow Functions
»
IF
»
298.1 .
Use and IF() and COUNT() to give us a total as COUNT() ignores NULL values
Hits: 1094
298.2 .
A number can also be returned from IF() function
Hits: 1170
298.3 .
Using IF() function to compare numbers
Hits: 1270
298.4 .
Using IF in where clause
Hits: 1220
298.5 .
Use IF with data in a table
Hits: 1220
298.6 .
Using IF with float point value
Hits: 1210
298.7 .
Using string comparison function with IF
Hits: 1173
298.8 .
IF(expr1,expr2,expr3)
Hits: 1265
MySQL TUTORIALS
Control Flow Functions
»
IF
Introdunction
IFNULL
CASE
NULLIF
IF
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View
Use and IF() and COUNT() to give us a total as COUNT() ignores NULL values
