Hi all, I've got a question. We were testing something on our mysql server ( 4.0.21) with MyISAM tables.
When we executed the query "select * from people where name like '';" we expected the same results as "select * from people where name='';" but it didn't. The like function returned everything instead of only the people without a name. Is this known (and correct) behaviour? It does not sound logical to me. I couldn't find anything about it on the mysql website. Thanks in advance! With regards, Casper Gondelach
