Check out example codes for "mysql select default if null". It will help you in understanding the concepts better.

Code Example 1

IFNULL(MAX(EMAIL), "[email protected]") as email

Learn ReactJs, React Native from akashmittal.com