If in mysql

Question

I need a simple if example in mysql. I do not want to consider another case only if the sentence

Answer 1

Example:

SELECT *,
       if (`date_last` IS NULL,prev_date,last_date) as date 
FROM `table_name` 
WHERE `id` = 2 
ORDER BY `date` DESC