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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted March 4, 2008 Share Posted March 4, 2008 you can't use = with null. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.