MS SQL에서 사용하는 ISNULL()은 MySQL에서 IFNULL()이라는 함수로 대체 가능. IFNULL(expr1,expr2) /* If expr1 is not NULL, IFNULL() returns expr1; otherwise it returns expr2. IFNULL() returns a numeric or string value, depending on the context in which it is used. */ SELECT IFNULL(1,0); /* -> 1 */ SELECT IFNULL(NULL,10); /* -> 10 */ SELECT IFNULL(1/0,10); /* -> 10 */ SELECT IFNULL(1/0,'yes'); /* -> 'yes' */