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

5 votes167 views2 answers
Oracle to_timestamp
SQL
0 vote183 views1 answer
Vowels in sql
SQL
3 votes191 views1 answer
Oracle list user grants
SQL
0 vote188 views1 answer
How to to get time in sql
SQL
1 vote191 views1 answer
Print year of a date sql
SQL
0 vote189 views1 answer
How to declare variable date in mysql
SQL
1 vote193 views1 answer
Update from select oracle
SQL
2 votes193 views5 answers
SQL trigger
SQL
0 vote216 views1 answer
Sql create and grant user access to database
SQL
-1 vote183 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL