case statement

Case statements help you use multiple if conditions in SQL queries. Here is how to write case statement in MySQL.