checking NULL or ''

[Mojtaba Faridzad]

Hi,

I tested these 2 queries:

select * from mytable where myfield is null;

select * from mytable where myfield = '';

The second one run faster. Is that true? Is checking NULL slower than
checking a string without any character?

Thanks


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