CODE EXAMPLE FOR SQL

mysql case when null

SELECT IF(guides.colName IS NULL, 'Yes','No') FROM tableName;

-- Or
SELECT
	CASE 
      WHEN colName IS NULL THEN 'Yes'
      ELSE 'No'
	END
FROM tableName;