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

1 vote336 views1 answer
How to remove identity from a column in sql server
SQL
0 vote314 views1 answer
Get first monday of month sql
SQL
14 votes349 views2 answers
Oracle limit rows
SQL
0 vote405 views1 answer
Calculer pourcentage mysql
SQL
0 vote367 views1 answer
Check constraint is violated
SQL
0 vote334 views1 answer
QCompleter con sql
SQL
24 votes329 views4 answers
Postgres remove database
SQL
0 vote349 views1 answer
Mysql config address
SQL
0 vote356 views1 answer
Pl/pgsql declare variable
SQL
0 vote334 views1 answer
With_for_update sqlalchemy
SQL