Re: Something is fishy in my selection

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. Results: 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" <mdumoulin@groupimage.com> a écrit dans le message de news: 20030206165051.89522.qmail@pb1.pair.com... > 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 me > 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 count: > > 6286+7 = 6293 > > Where is my last line??? Could this be a bug in the IN, NOT IN statements of > mysql? or is this part of a problem related to phpMyAdmin? I will try to run > 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 can > find something wrong in my doing, it's only logical that i should get all > lines!!! > > Mathieu > >