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 vote157 views1 answer
Sql comparison operators
SQL
0 vote162 views1 answer
1 column values in to 1 single row in sql
SQL
3 votes156 views1 answer
What is having clause
SQL
0 vote161 views1 answer
How to check if there is no database schema
SQL
2 votes158 views2 answers
Mysql all columns
SQL
1 vote168 views1 answer
Mariadb alter user host
SQL
0 vote222 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote179 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote175 views1 answer
Ms sql filter all sympbol
SQL
4 votes158 views2 answers
How to delete row in sql
SQL