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