From: Mike Johnson [mailto:[EMAIL PROTECTED] > From: Martin Rytz [mailto:[EMAIL PROTECTED] > > > Hi MySQL-Users > > > > I have a simple select statement like 'select id from table'. > > The result is 0, becaues the id field is 0 (int-field). > > > > My problem is now how to suppress the 0 and give NULL instead > > of 0 as the result (i.E. everytime the result from the select > > is 0 it should be NULL). > > > > How can this be done within the select-statement? > > SELECT IF(id = 1, NULL, id) AS id ... > > The usage of IF() is IF(expression, true value, false value).
Oops, my mistake. Should have been IF(id = 0, NULL, id). I was testing on a table without `0' values. Sorry for the mix-up. -- Mike Johnson Smarter Living, Inc. Web Developer www.smarterliving.com [EMAIL PROTECTED] (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]