How to do this multiple IF statement in MySQL

How to do this multiple IF statement in MySQL

References

Reference NO 1

http://dev.mysql.com/doc/refman/5.0/en/if.html

Reference NO 2

http://stackoverflow.com/questions/15165192/how-to-do-this-multiple-if-statement-in-mysql

Reference NO 3

http://stackoverflow.com/questions/5008503/multiple-condition-in-a-single-if-in-select-query

Reference NO 4

http://komlenic.com/254/mysql-nested-if-in-select-queries/

Reference NO 5

http://my.safaribooksonline.com/book/databases/mysql/0596100892/blocks-conditional-statements-and-iterative-programming/mysqlspp-chp-4-sect-2

Reference NO 6

http://timmurphy.org/2009/08/13/inline-if-and-case-statements-in-mysql/

Reference NO 7

http://w3schools.invisionzone.com/index.php?showtopic=44100

Reference NO 8

http://www.sitepoint.com/forums/showthread.php?47728-MySQL-Multiple-Condition-in-WHERE-clause