Answers for "mysql case when null"

SQL
0

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;
Posted by: Guest on August-13-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language