MYSQL SELECT CASE:
In Mysql Case is like normal switch case in java, we can use for different results to display in select query.
Use case:
Here we have the table tab1
from this table cname column
- if a represents we have to display as apple
- Null represents display as NA
- others display as it is.
SQL QUERY :
SELECT id,case
when cname='a' THEN 'APPLE'
when cname IS NULL THEN 'NA'
else cname end FROM tab1 ;
RESULT:
