Things which can be done with MYSQL instead of involving PHP [closed]

[GrootsHarmomo]

What are the must-know MYSQL functions (like IF etc..,) which every web developer should know?