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 vote231 views2 answers
How to drop mili second in sql
SQL
2 votes228 views1 answer
Install postgresql centos 5
SQL
0 vote191 views1 answer
Postgres add prefix to primary key
SQL
0 vote204 views1 answer
Sql server select ignore dupplicates
SQL
-1 vote187 views1 answer
How to format tables in sqlplus
SQL
3 votes200 views2 answers
How to start mysql in terminal
SQL
0 vote206 views1 answer
Subquery aggregation
SQL
0 vote194 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote263 views1 answer
What is metadata in sql
SQL
0 vote205 views1 answer
Mysql failed to login as root@localhost
SQL