IF « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. IF
1.The IF() function compares three expressions, as shown in the following syntax:
2.Use an IF function to evaluate which designs sell over 500 units during the winter sales quarter
3.SELECT IF('02-29' < '03-01','02-29','03-01') AS earliest;
4.IF(condition, result1, result2)
5.Mapping NULL Values to Other Values for Display
6.display GB value with IF() that maps 0 to a dash