select count(*) from members where country_id = 1 and read_array is NULL ;
Daren Cotter wrote:
> can anybody explain this to me?
>
> mysql> select count(*) from members where country_id = 1 and read_array not
> like '%20270%';
> +--+
> | count(*) |
> +--+
> |34884 |
> +-
I would have to guess that you have a broken index.
bill
-Original Message-
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 3:50 PM
To: [EMAIL PROTECTED]
Subject: very strange query behavior
can anybody explain this to me?
mysql> select count(*) from memb