select count(*) from user where username like 'a%';
select count(*) from user where username not like 'a%' or username is null;
is not the same for all letters of the alphabet:
letter like not-like sum
n 2304 59317 61621
o 0 60797 60797
p 3048 58573 61621
Sounds like a corrupt index. Try CHECK TABLE and REPAIR TABLE.
Tried that, tried myisamchk as well, everything seems to be healthy, still
the problem exists.
Zoltan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]