mySQL if else statement?

mySQL if else statement?

References

Reference NO 1

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

Reference NO 2

http://stackoverflow.com/questions/4180218/mysql-if-else-statement

Reference NO 3

http://stackoverflow.com/questions/11001653/sql-if-else-statement

Reference NO 4

http://stackoverflow.com/questions/8763310/mysql-if-else-statement-in-query

Reference NO 5

http://stackoverflow.com/questions/5951157/mysql-if-in-select-statement

Reference NO 6

#EANF#

Reference NO 7

#EANF#

Reference NO 8

#EANF#