Bob Hall wrote:
I want to do a select like
select id from test
where id in (select id from test where value in (1,2,3)
and id in (select id from test where value in (4,6,7)
and id in (select id from test where value in (1,6,25)
Even if MySQL supported subqueries, this
Does anybody know what is the fastest way to run a large multiple
AND type query on a many-many table and the least memory hungry.
Sir, what is a type query, and what in the world is a many-many table?
For example if I have
create table test (id int, value int);
which has many-to-many on
Bob Hall wrote:
I want to do a select like
select id from test
where id in (select id from test where value in (1,2,3)
and id in (select id from test where value in (4,6,7)
and id in (select id from test where value in (1,6,25)
Even if MySQL supported subqueries, this query would
Steve Ruby wrote:
Does anybody know what is the fastest way to run a large multiple
AND type query on a many-many table and the least memory hungry.
For example if I have
create table test (id int, value int);
which has many-to-many on id, and value
I want to do a select like