SELECT IFNULL(column_name, default_value 'Test') AS alias FROM table; --example SELECT first_name, IFNULL(title, 'MISSING') as title, IFNULL(grade, 0) as grade FROM students