Hi

I have a problem in my search, I search in a table for "like ..." and "not like ..." and I still end up with less than all the rows...

Here it is:

SELECT count(*) FROM cases WHERE username like "karops" and completed>="2001-01-01" and completed<="2001-12-31"

result: 264 hits

SELECT count(*) FROM cases WHERE username like "karops" and completed>="2001-01-01" and completed<="2001-12-31" and finished like "yes"

result: 212 hits

The final search should result in (264-212) hits (52):

SELECT count(*) FROM cases WHERE username like "karops" and completed>="2001-01-01" and completed<="2001-12-31" and finished not like "yes"

But it only results in 38 hits...

I have tried exchanging like and not like with == and != ... Same result

Is this a problem with mysql, the search or what?