> 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.
You are correct, sir. http://www.mysql.com/doc/en/NULL_values.html http://www.mysql.com/doc/en/Working_with_NULL.html http://www.mysql.com/doc/en/Problems_with_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 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 faster. Is that true? Is checking NULL slower than > checking a string without any character? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
