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 vote125 views2 answers
Update query with between in mysql
SQL
0 vote123 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
-1 vote119 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote120 views1 answer
Html css mobile menu arrow dropdown
SQL
11 votes121 views1 answer
Ddl materialized view
SQL
17 votes109 views2 answers
How to assign date field for table in mysql
SQL
2 votes115 views1 answer
Mysql select default if null
SQL
2 votes125 views2 answers
Run mysql command from bash
SQL
3 votes120 views2 answers
Df to sql pandas sql achemy
SQL
1 vote130 views2 answers
Check if word is in column sql
SQL