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 vote242 views1 answer
Double in sql server example
SQL
2 votes288 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote261 views1 answer
Char vs varchar2 in sql
SQL
0 vote260 views1 answer
Mysql url data type
SQL
0 vote228 views1 answer
Sqlite3 now
SQL
0 vote242 views1 answer
Oracle execute immediate quotes
SQL
3 votes287 views3 answers
Update con select postgresql
SQL
3 votes269 views1 answer
Oracle list user grants
SQL
1 vote248 views1 answer
Return size of tables in mysql
SQL
1 vote254 views3 answers
Sql server get week dates from week number
SQL