MySQL the same field from two different rows?

[cashpath]

Is it possible to run a MySQL query that will pull the same field but from two different rows? Using two different WHERE clauses? Could someone show me an example of how that would be done?

[bluesoul]

SELECT fieldid FROM table WHERE fieldid IN (1,4,7)

Where 1,4, and 7 are the different rows you are looking for.

[cashpath]

ok lets say this is the code

SELECT rank FROM table WHERE week=5

But I also want to SELECT rank FROM table WHERE week=4 too and have it in the same row on the result.

[bluesoul]

I'm not sure I follow, you can do:
SELECT rank FROM [table] WHERE week IN(4,5);
And they'll show up in their respective rows. Putting them side by side in the same row would be a formatting thing, more cosmetic than anything. I think you'll be better off formatting your results through PHP or whatever language you're using.

[cashpath]

Ok :) so the answer is no...

Thanks.

[Michael Biddle]

Not sure exactly what you mean?

if you want two differnt ones, run 2 seperate quieres.

[ElfMage]

You could do this by using a cross join (also referred to as table product):


SELECT t1.rank, t2.rank FROM table t1, table t2 WHERE t1.week=5 AND t2.week=4

[cashpath]

Ok thanks Elfmage..



Not sure exactly what you mean?

if you want two differnt ones, run 2 seperate quieres.
I was trying to eliminate the amount of queries I was running.

[Michael Biddle]

you could also do a left join for this then