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

10 votes170 views2 answers
Sql where clause multiple values
SQL
4 votes200 views1 answer
Mysql biginteger size
SQL
0 vote214 views1 answer
Mysql min value row
SQL
5 votes193 views1 answer
Oracle ORA-00054 origin
SQL
-1 vote223 views4 answers
Restart mysql server ubuntu
SQL
0 vote202 views2 answers
How to delete the rows with null values in mysql
SQL
2 votes215 views1 answer
Oracle find unusable indexes
SQL
0 vote181 views1 answer
Deny select insert update delete sql
SQL
0 vote201 views1 answer
Mysql root permission denied lost
SQL
0 vote215 views1 answer
How to create a table in sql stack overflow
SQL