Solution 1:
Used
select coalesce(column_1,'No Value')
from my_table
and it worked like a charm. Just replaced the NULL values in the table with my desired string.
MariaDB - Want to change default value from "NULL" to an actual String
Solution 1:
Used
select coalesce(column_1,'No Value')
from my_table
and it worked like a charm. Just replaced the NULL values in the table with my desired string.