'Return all values and alternate a null column

I have 6 columns in a table, and a column called uuid has a null value for some rows.

I want to return any null value with "" and return all columns and rows, I've search around and seen some solutions with IFNULL, COALESCE but i seem to get the syntax wrong.

mysqlsqlnullcoalesceisnull


Solution 1:[1]

UPDATE table SET uuid = '' WHERE uuid IS NULL;
SELECT * FROM table;

These two should do the trick or do you just want to replace the null for this one query only and not permanently change it to ''?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Rowan

Related Questions