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

0 vote370 views3 answers
Select random sql
SQL
0 vote355 views1 answer
Copied text from internet not inserting in mysql
SQL
1 vote349 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
5 votes401 views1 answer
Oracle source query
SQL
14 votes440 views1 answer
How to export db from mysql
SQL
1 vote364 views1 answer
How to group by month using sql server
SQL
1 vote386 views2 answers
Oracle create synonym
SQL
5 votes348 views2 answers
Mysql drop table cascade
SQL
0 vote367 views1 answer
Mysql subdate
SQL
3 votes375 views1 answer
Oracle drop user
SQL