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 votes102 views1 answer
Install sqlite npm
SQL
0 vote118 views1 answer
Helptext in sql
SQL
0 vote105 views2 answers
Sql join on comma separated field
SQL
0 vote101 views1 answer
Is numeric in sql
SQL
0 vote114 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote113 views1 answer
Create synonym for dblink in oracle
SQL
1 vote121 views1 answer
Liquibase alter column type / length
SQL
13 votes149 views6 answers
Mysql remove duplicates
SQL
2 votes108 views1 answer
Get first n letter of department name in sql
SQL
2 votes102 views1 answer
Oracle sql concatenate results into string
SQL