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 vote313 views1 answer
Mysql dump everythign
SQL
7 votes337 views2 answers
Where keyword sql
SQL
0 vote312 views1 answer
Kotlin sqlite delete row
SQL
4 votes312 views1 answer
Sql delete where in select
SQL
0 vote283 views1 answer
Create duplicate table in postgresql
SQL
0 vote287 views1 answer
Metada in sql
SQL
1 vote315 views1 answer
Simple project for database
SQL
4 votes309 views2 answers
What is table in sql
SQL
31 votes332 views4 answers
Mysql grant execute
SQL
3 votes336 views1 answer
APEX elapsed time
SQL