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 vote197 views1 answer
Postgresql get current user name
SQL
0 vote217 views1 answer
Modificar tipo de dato sql server
SQL
0 vote225 views1 answer
Transaction database with php
SQL
1 vote207 views3 answers
Rename table snowflake
SQL
3 votes226 views2 answers
Oracle apex view logs
SQL
0 vote215 views1 answer
Install postgresql 12 on debian 10
SQL
25 votes211 views3 answers
Mysql command show tables
SQL
0 vote231 views3 answers
Mysql regex replace
SQL
4 votes249 views4 answers
Mysql get date from datetime
SQL
0 vote217 views1 answer
How to get data between a last week in mysql
SQL