MySQL the same field from two different rows?
 

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?

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

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

ok lets say this is the code

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

I'm not sure I follow, you can do:
[sql]SELECT rank FROM [table] WHERE week IN(4,5);[/sql]
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.

Ok :) so the answer is no...

Thanks.

Not sure exactly what you mean?

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

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

Ok thanks Elfmage..


I was trying to eliminate the amount of queries I was running.

you could also do a left join for this then