mysql null 값 치환

SELECT id, status_id, SUBJECT, IFNULL(date,'값이없습니다.'), created_on, updated_on  FROM issues WHERE status_id='1' OR status_id='6' ORDER BY id DESC LIMIT 1000