mysql ifnull 대신 IfNullOrEmpty 사용하기

DELIMITER $$
-- --------------------------------------------------------------------------------
-- Routine DDL
-- --------------------------------------------------------------------------------
-- Note: add your server side comments to remember what this routine does on your Api
-- --------------------------------------------------------------------------------
DROP FUNCTION IF EXISTS `IfNullOrEmpty`$$
CREATE FUNCTION `IfNullOrEmpty`(s TEXT, value TEXT) RETURNS TEXT
NOT DETERMINISTIC
READS SQL DATA
BEGIN

IF ( (s is null) OR (trim(s) = '')  ) THEN
    return value;
END IF;
return s;    
END$$

SELECT IfNullOrEmpty(t.FieldName,'No Name ') as Name FROM cms_Table t




ifnull 만 할 경우 '' 빈 문자열 체크가 안되어 IfNullOrEmpty 만들어서 사용