MS SQL에서 IFNULL(컬럼, 0) 컬럼값이 null이면, 0을 넣는 함수가 있습니다. MySQL에서는 COALESCE(컬럼, 0)을 이용해서 null이면, 0을 넣는 함수를 사용합니다. 출처: ISNULL(value, 0) in WHERE clause MYSQL I believe you are trying to use the IFNULL() function. IF you replaced with IFNULL that should fix your query. I suggest you go one step further and use COALESCE() instead of IFNULL(), since COALESCE() is part of the SQL standard (and IFNULL() is ..