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 vote195 views1 answer
How to use update trigger in sql
SQL
3 votes231 views1 answer
Laravel paginate raw sql
SQL
5 votes215 views2 answers
Create function postgresql
SQL
-2 votes305 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote223 views1 answer
How to run mysql in git bash
SQL
2 votes265 views2 answers
Mysql date range
SQL
3 votes195 views2 answers
Mysql update row
SQL
0 vote192 views1 answer
Set column width in sqlplus
SQL
0 vote237 views1 answer
Show tables in cassandra cql
SQL
19 votes205 views5 answers
Change column name mysql command line
SQL