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

4 votes94 views3 answers
Oracle sql first day of quarter
SQL
0 vote102 views2 answers
Dbms interview questions
SQL
1 vote108 views1 answer
Key validation sql
SQL
0 vote120 views1 answer
Mysql get only the field names in a table
SQL
2 votes107 views1 answer
Add new column not null sql server
SQL
0 vote94 views1 answer
Tinydb add table
SQL
0 vote132 views1 answer
Mysql 3 months ago
SQL
0 vote107 views1 answer
Dapper run sql script with parameters
SQL
2 votes101 views1 answer
Cast string to datetime mysql
SQL
5 votes119 views1 answer
Oracle create table comment
SQL