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 vote406 views1 answer
How to Activate the database
SQL
0 vote329 views1 answer
Find largest table in mysql database
SQL
2 votes328 views1 answer
Check isolation level in mysql
SQL
0 vote358 views3 answers
Run sql command line
SQL
6 votes347 views2 answers
Non relational database
SQL
2 votes324 views1 answer
How to add where command in update comand with joins
SQL
15 votes504 views2 answers
Sql order by alphabetical
SQL
-2 votes333 views1 answer
Modify column name in tsql
SQL
0 vote357 views1 answer
Create a sql server database programmatically
SQL
8 votes374 views2 answers
How to fetch data from database without last column
SQL