SQL
MySQL CASE Function
Go through conditions and return a value when the first condition is met: