More info on this problem, i tried running the queries (the NOT IN and the
IN) while TRIM() the field compared just to see  and i did that in a web
page directly thru the mysql<=>php api.


Trimming and using in list: 6286
Trimming and using not in list: 7
Not trimming and using in list: 6286
Not trimming and using not in list: 7

So no change...
This seems to be a bug in mysql...

Mathieu Dumoulin

"Mathieu Dumoulin" <[EMAIL PROTECTED]> a écrit dans le message de
> Hi there, want to say this right off the start the calculations here are
> used with the totals of the results and not the range so dont go telling
> that i might have used a 0 based index, NO...
> I have 6294 lines in my table
> i query with a IN (...) statement and i get 6286 lines out of my DB
> i query again using the same list but with NOT IN (...) and i get 7 lines
> Theoricaly, i should get all lines thru this way of doing right? Well
> 6286+7 = 6293
> Where is my last line??? Could this be a bug in the IN, NOT IN statements
> mysql? or is this part of a problem related to phpMyAdmin? I will try to
> these queries right off a web page using the direct api to the mysql
> database to see if it's in phpMyAdmin or mysql, till then i hope someone
> find something wrong in my doing, it's only logical that i should get all
> lines!!!
> Mathieu

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to