Re: LIKE problem?

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

LIKE problem?

Recently I ran into a problem with 'LIKE' in mysql on Debian Sarge: mysql> select VERSION(); +---+ | VERSION() | +---+ | 4.1.11-Debian_4sarge2-log | +---+ 1 row in set (0.00 sec) with the following table: CR