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

1 vote179 views1 answer
Drop df constraint sql server
SQL
0 vote169 views1 answer
Sql view index
SQL
3 votes163 views1 answer
MySQL DELETE JOIN
SQL
0 vote191 views1 answer
Sql server roles and users
SQL
0 vote326 views1 answer
How to find the most occuring in SQL
SQL
0 vote196 views3 answers
Run sql command line
SQL
0 vote212 views1 answer
Get initial in sql
SQL
0 vote183 views1 answer
Ms sql filter all sympbol
SQL
0 vote176 views1 answer
Create synonym for dblink in oracle
SQL
11 votes356 views4 answers
Round in sql
SQL