Hi

How can I make a select from query to obtain results of two different values in the same column?

thanks

use OR or AND in the WHERE criteria

?
Do you mean take 2 different values from the same column result?

or take 2 different columns and put them together?

Im a little cunfuzzed ? or maybe to drunk.

Originally Posted by lynxus

?
Do you mean take 2 different values from the same column result?

or take 2 different columns and put them together?

Im a little cunfuzzed ? or maybe to drunk.

lol

I did:

$sql="SELECT * FROM wallet WHERE imagem!=0 and country IN (Usa,Canada) limit 4";

$sql="SELECT * FROM wallet WHERE imagem!=0 and country='(Usa,Canada)' limit 4";


But does not work

IN ('USA','Canada')

SELECT column1, column2 FROM tablename WHERE recordid=(value you are looking for)

Hope thats what you are looking for or should I say be more specific please.

Originally Posted by chrishirst

IN ('USA','Canada')

It is working. Thanks

But another question:

can I use:

sql * from table where image!=0 and country IN('Usa','Canada') and IN city('NY',Toronto') limit 4 (/code) in the same query?

You can, though NOT using SELECT * would be MUCH better and correcting the syntax on "and city IN('NY',Toronto') ...

Originally Posted by chrishirst

You can, though NOT using SELECT * would be MUCH better and correcting the syntax on "and city IN('NY',Toronto') ...

Ok. Thank you very much for the help.

be good!!!