Need help with a query

[Michael Morris]

Here it is

[sql]SELECT * FROM post
WHERE userid = 1
AND postid IN SELECT reviewids from product where productid = 3 [/sql]

The product table has a field called reviewids which is a list of reviewsids in this format 980,1020,2212

I know I can execute a single query to grab the ids and a second query to make this check (which should return true or false), but I'd rather do it in one query if I can.

[Dean C]

Nothing wrong with a subquery if you can do it

[sabret00the]

wouldn't he need to explode and FIND_IN_SET the original listed data if it's in the format of 454,5656,34232,134?

[Dean C]

If he's using MySQL4 then he can use subqueries Personally for scalability I'd get a list of ID's, and then use WHERE productid IN($ids)

[Michael Morris]

Ah.. Well, I'm not using 4+. I broke it in half pretty much as you described Dean. Thx.