MySql Query Replace NULL with Empty String in Select

January 27, 2023 by Tarik

If you really must output every values including the NULL ones:

select IFNULL(prereq,"") from test