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 vote258 views1 answer
How not to sort by average rating
SQL
-2 votes207 views1 answer
Remove root password mysql
SQL
0 vote209 views1 answer
Show database not empty tables postgres
SQL
0 vote220 views1 answer
How to find columns with null values in sql
SQL
0 vote220 views1 answer
Primary key start from number
SQL
0 vote221 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote211 views1 answer
Ubuntu connect to mssql database
SQL
0 vote188 views1 answer
Describe in sqlite3
SQL
0 vote208 views2 answers
Tsql row number
SQL
0 vote202 views1 answer
Sqlite commands
SQL