select if condition in mysql

https://stackoverflow.com/questions/31962449/mysql-select-column-if-not-null-only

SELECT IFNULL(firstname,'') AS firstname, 
IFNULL(lastname,'') AS lastname, 
IFNULL(age,'') AS age, 
IFNULL(gender,'') AS gender 
FROM persons WHERE id = 1;