Hi Dan, all!
Dan Rossi wrote:
Hi, im having some issues with a sub query in mysql5 , i have a field
which is storing a static comma seperate list of primary keys ie 1,2,3,4
Call me pedantic, but I get suspicious:
Is that a list of the four values "1", "2", "3", "4", or is it rather a
single
Dan,
>SELECT count(*)
>FROM feeds
>WHERE feedID IN (
> SELECT feeds FROM month_totals
> WHERE customerID=9 AND month_unique=1105
>)
>expected result should be 4 , i get 1. If i manually put in
> SELECT count(*) FROM feeds WHERE feedID IN (1,2,3,4)
>for instance i get 4
Why the subquery? Aren'
Hi, im having some issues with a sub query in mysql5 , i have a field
which is storing a static comma seperate list of primary keys ie
1,2,3,4 , i am then trying to use that to find entries in another table
of the same primary keys here is the sql
SELECT count(*) FROM feeds WHERE feedID IN (SE