Hi,
Moreover, the sum of the results of these two queries
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.
Regards,
Jeremy
--
Jeremy Cole
MySQL Geek, Yahoo! Inc.
Desk: 408 349 5104
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]