If statment in query

[Sebastian]

I have two fields: topic | title

topic 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.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]