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

3 votes312 views1 answer
Sql online test questions and answers
SQL
0 vote327 views1 answer
Mysql db dump restore max file size issue
SQL
6 votes299 views4 answers
Eloquent to sql with bindings
SQL
2 votes290 views1 answer
Oracle cpu per session
SQL
0 vote317 views1 answer
Mysql backup certain tables workbench
SQL
0 vote292 views1 answer
Sql gap missing values
SQL
0 vote326 views1 answer
Prodection ready postgres database step by step
SQL
0 vote261 views1 answer
Sql select rows with simlar names
SQL
2 votes291 views1 answer
Sql like variable
SQL
0 vote318 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL