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

4 votes169 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote140 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
1 vote130 views1 answer
Hackerrank sql test solutions
SQL
0 vote138 views1 answer
Sql #region
SQL
2 votes95 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote139 views1 answer
Ffeathers express mysql application users login
SQL
3 votes159 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
-2 votes136 views2 answers
Sqlserver docker
SQL
1 vote215 views1 answer
Mysql breakline on string
SQL
5 votes131 views1 answer
How to get all dates in a month in oracle
SQL