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 votes276 views1 answer
Oracle all_dependencies
SQL
0 vote262 views1 answer
SQL joins in python
SQL
1 vote178 views1 answer
Launch sql script from docker in mysql
SQL
3 votes223 views3 answers
1396(hy00) mysql error
SQL
16 votes217 views2 answers
Sql exists
SQL
18 votes192 views4 answers
Foreign key mySql
SQL
0 vote210 views1 answer
T sql dynamic top n query
SQL
0 vote220 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote196 views1 answer
Sql find all different values in column
SQL
0 vote189 views1 answer
Cast for print sql
SQL