h_NULL.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Roddie Grant" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, 16 June, 2003 10:52
Subject: Re: checking NULL or ''
I'm still a bit of newbie, but surel
I'm still a bit of newbie, but surely these are not the same query. The
empty string is not the same thing as NULL.
Roddie Grant
[EMAIL PROTECTED]
> I tested these 2 queries:
>
> select * from mytable where myfield is null;
>
> select * from mytable where myfield = '';
>
> The second one run f
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://
