I'm trying to retreive list of site ids from a table,but I noticed that the order in the *in* clause returnes different results...
here is some info about my table:
-------------------------------
siteid field type: counter
Index on fields:metamorph inverted copmound index on 3 fields: (Title\Body,topics\categories,siteid)
No records exist for the siteid value '31c3ds7h4c'
702 records exist for the siteid value '3b13ad7f4c8'
Here is first query, I use ('31c3ds7h4c','3b13ad7f4c8')
which returns only 1 result..
select count(*) from dailythreads where Title\Body like '+bmw @0 w/all' and siteid in('31c3ds7h4c','3b13ad7f4c8')
Here is the second query,I use
Which returns 702 results..('3b13ad7f4c8','31c3ds7h4c')"
tsql "select count(*) from dataTable where Title\Body like '+bmw @0 w/all' and siteid in('3b13ad7f4c8','31c3ds7h4c')"
Is there any reason why is that happening??
Thanks..
here is some info about my table:
-------------------------------
siteid field type: counter
Index on fields:metamorph inverted copmound index on 3 fields: (Title\Body,topics\categories,siteid)
No records exist for the siteid value '31c3ds7h4c'
702 records exist for the siteid value '3b13ad7f4c8'
Here is first query, I use ('31c3ds7h4c','3b13ad7f4c8')
which returns only 1 result..
select count(*) from dailythreads where Title\Body like '+bmw @0 w/all' and siteid in('31c3ds7h4c','3b13ad7f4c8')
Here is the second query,I use
Which returns 702 results..('3b13ad7f4c8','31c3ds7h4c')"
tsql "select count(*) from dataTable where Title\Body like '+bmw @0 w/all' and siteid in('3b13ad7f4c8','31c3ds7h4c')"
Is there any reason why is that happening??
Thanks..