MySQL resultset to array for use in WHERE clause

Question

I've been trying to understand how this works, and so far, I found a workaround but it's not as nice as I had hoped.

Say I get some resultset from a query like so:

SELECT id FROM photos WHERE some clause

And I'd like put the resultset in a where clause like so:

SELECT * FROM tags WHERE photo_id IN ( array I just received )

How would I do this with a nested query? I tried looking up subqueries to no avail. Joins are not my strong suit but I fear I will need them in this case.

Popnoodles · Accepted Answer · 2013-01-04 21:08:49Z

2

SELECT * FROM tags WHERE photo_id IN (SELECT id FROM photos WHERE some clause)

but this should also work:

SELECT tags.* FROM tags INNER JOIN photos ON (tags.photo_id=photos.id AND some clause)

answered Jan 4, 2013 at 21:08

Popnoodles

28.4k3 gold badges49 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user827080 Over a year ago

Okay so I was right in both hunches.. thanks a bunch, will test now.

Collectives™ on Stack Overflow

MySQL resultset to array for use in WHERE clause

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related