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;

Similar codes

6 votes108 views2 answers
Join vs union
SQL
0 vote96 views1 answer
Change date format in oracle query
SQL
0 vote99 views1 answer
Check connections to database postgres
SQL
4 votes113 views1 answer
Group by mysql and concatenate string
SQL
1 vote100 views1 answer
Update and replace mysql
SQL
2 votes89 views2 answers
Get all columns from table sql
SQL
1 vote111 views1 answer
Myql find duplicates
SQL
0 vote104 views1 answer
Where date in datetime mysql
SQL
0 vote99 views1 answer
Renommer schema sql
SQL
0 vote104 views1 answer
Connect postgresql using a connection string
SQL