Sebastian wrote:
I have two fields: topic | titletopic does not always have data in it, so i want to select `title` when `topic` is null..i thought i could do this (does not work): IF(title IS NULL, topic, title) AS heading Thanks.
Try SELECT IFNULL(title, topic) AS heading -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]