Conditional in Mysql

Question

I would like to get a string obeying a condition in Mysql. For example I have a table with a column name descritor which is filled with PT or MT, would like to get the string Português for PT and Matemática for MT in a consultation.

Example:

If descriptor = PT then Português

If descriptor = MT then Matemática

Answer 1

You can use CASE WHEN for that reason:

SELECT *,
CASE descritor  
    WHEN 'PT' THEN 'Português' 
    WHEN 'MT' THEN 'Matemática'
END AS Disciplina
FROM Tabela