Mysql cast null to string

#If you really must output every values including the NULL ones
select IFNULL(prereq,"") from test

#OR, Coalesce will return the first non-null argument passed to it
#from left to right. If all arguemnts are null, it'll return null, but we're forcing an empty string there, so no null values will be returned.
SELECT COALESCE(prereq, '') FROM test

Source: stackoverflow.com

Similar codes

-1 vote257 views1 answer
Insert results of a stored procedure into a temporary table
SQL
-1 vote257 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote262 views1 answer
How to get table current identity value in sql server
SQL
0 vote274 views1 answer
Isnull in sqlite
SQL
0 vote256 views1 answer
Postgres full text search example
SQL
1 vote247 views1 answer
Select statement to print longest name
SQL
1 vote251 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote261 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote312 views1 answer
Python dictionary to sql update
SQL
0 vote265 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL