Re: very strange query behavior

[Gerald Clark]

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 |
> +--+
> 
> mysql> select count(*) from members where country_id = 1 and read_array like
> '%20270%';
> +--+
> | count(*) |
> +--+
> |13554 |
> +--+
> 
> mysql> select count(*) from members where country_id = 1;
> +--+
> | count(*) |
> +--+
> |63546 |
> +--+
> 
> 34884 + 13554 <> 63546
> 
> This is a very important aspect of our business, can anyone offer any
> insight as to what may be wrong?
> 
> TIA,
> 
> 
> 
> 
> Sincerely,
> 
> Daren Cotter
> CEO, InboxDollars.com
> [EMAIL PROTECTED]
> http://www.inboxdollars.com
> (507) 382-0435
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: very strange query behavior

[Bill Blowitz]

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 members where country_id = 1 and read_array not
like '%20270%';
+--+
| count(*) |
+--+
|34884 |
+--+

mysql> select count(*) from members where country_id = 1 and read_array like
'%20270%';
+--+
| count(*) |
+--+
|13554 |
+--+

mysql> select count(*) from members where country_id = 1;
+--+
| count(*) |
+--+
|63546 |
+--+

34884 + 13554 <> 63546

This is a very important aspect of our business, can anyone offer any
insight as to what may be wrong?

TIA,




Sincerely,

Daren Cotter
CEO, InboxDollars.com
[EMAIL PROTECTED]
http://www.inboxdollars.com
(507) 382-0435


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php