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

2 votes212 views1 answer
Mysql auto increment jumping
SQL
-1 vote221 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote187 views1 answer
Calculate discount from original price sql
SQL
0 vote246 views1 answer
C# get sql min date
SQL
4 votes288 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote240 views1 answer
Least spark sql
SQL
2 votes289 views3 answers
Mysql unix timestamp to date
SQL
0 vote203 views1 answer
Get only first row mysql
SQL
0 vote236 views1 answer
Connect to nginx server mysql remotly
SQL
14 votes248 views3 answers
Inner join sql oracle
SQL