What does ISNULL do exactly?
Posted on 2004-09-16
I'm trying to translate a SQL Server application to work in MySql. The MySql server burps when I send it this statement:
SELECT * FROM MYTABLE WHERE MYFIELD=ISNULL(%s)
The %s can be a string containing 'sumting' or a a string containing the word NULL
I was wondering what does the command ISNULL do exactly.
I know that if I do this in MySQL:
SELECT * FROM MYTABLE WHERE MYFIELD IS NULL
then I lose the search for 'sumting'...