Re: Something is fishy in my selection

Oh crap, someone mailed me about having nulls in my field compared... you can no disregard this thread...its closed i got the culprit, it's a stupid NULL i found in a column Mathieu Dumoulin "Mathieu Dumoulin" <mdumoulin@groupimage.com> a écrit dans le message de news: 20030206170834.239.qmail@pb1.pair.com... > 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 > > > > > >