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 vote99 views1 answer
Groupby sort sql hive
SQL
0 vote102 views1 answer
Postgresql combine values in one field
SQL
0 vote102 views1 answer
Firebase sql
SQL
0 vote55 views1 answer
Check id exist or not in sql
SQL
0 vote118 views1 answer
Least spark sql
SQL
-1 vote96 views1 answer
How to format tables in sqlplus
SQL
1 vote118 views1 answer
Delete specific row in sql
SQL
0 vote112 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote122 views1 answer
On delete set default
SQL
3 votes103 views4 answers
Mysql decimal
SQL