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

0 vote283 views1 answer
Sql server query database space available
SQL
0 vote273 views4 answers
Best data type to represent money in mysql
SQL
0 vote325 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
-1 vote289 views2 answers
Create temporary table sql
SQL
0 vote254 views1 answer
Alter session set nls_language french
SQL
1 vote273 views1 answer
Oracle add proxy
SQL
0 vote268 views1 answer
Why mysql is used?
SQL
0 vote283 views1 answer
Max mysql
SQL
0 vote312 views2 answers
How to install psql in ubuntu
SQL
0 vote262 views1 answer
Check mysql password with docker container magento 2
SQL