trilbyfish Posted March 2, 2008 Share Posted March 2, 2008 I have a mysql table with columns `baynumber`, `08:00 - 09:00`, `09:00 - 10:00`, `10:00 - 11:00`, `11:00 - 12:00`, `12:00 - 13:00`, `13:00 - 14:00`, `14:00 - 15:00`, `15:00 - 16:00`, `16:00 - 17:00` , but how can i replace a blank value in all of these columns with something such as 'empty'. I think the COALESCE function is needed but i cant figure out how to use it in a table with more than a few columns. It needs to be something that just prints the sql table by replacing the null value with something, rather than updating the table by replacing null cells with values. Thanks in advance Link to comment https://forums.phpfreaks.com/topic/94080-sql-replace-null-values/ Share on other sites More sharing options...
teng84 Posted March 3, 2008 Share Posted March 3, 2008 this? select if(field = null, 'yes',field) from table Link to comment https://forums.phpfreaks.com/topic/94080-sql-replace-null-values/#findComment-482095 Share on other sites More sharing options...
fenway Posted March 4, 2008 Share Posted March 4, 2008 you can't use = with null. Link to comment https://forums.phpfreaks.com/topic/94080-sql-replace-null-values/#findComment-483265 Share on other sites More sharing options...
aschk Posted March 5, 2008 Share Posted March 5, 2008 Hmm, i posted on this a few days ago, was the phpfreaks database rolled back by chance? SELECT IFNULL(field,'yes') FROM table Link to comment https://forums.phpfreaks.com/topic/94080-sql-replace-null-values/#findComment-483738 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.