>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 sup
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 qu
>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
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 selec
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
select id from test
where id