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]
