MYSQL SELECT question

harper · #1 (**permalink**) 01-23-06, 16:38

I have this statement

SELECT *FROM `data`WHERE `symbol` = 'PUB1'

how do i modify this statement to also select PUB2 and PUB6 ?

healdem · #2 (**permalink**) 01-24-06, 02:56

SELECT *FROM data WHERE symbol in ("PUB1", "PUB2"...."Pubn");

harper · #3 (**permalink**) 01-24-06, 13:20

Quote:

Originally Posted by healdem

SELECT *FROM data WHERE symbol in ("PUB1", "PUB2"...."Pubn");

yes it works thanks very much

harper · #4 (**permalink**) 01-24-06, 16:52

I also have this situation with two tables

SELECT *FROM data WHERE symbol in ("PUB1", "PUB2"...."Pubn");
SELECT *FROM basket WHERE symbol in ("PUB1", "PUB2"...."Pubn");

is it possible to select to combine both tables ordered by symbol for the symbols ("PUB1", "PUB2"...."Pubn")

healdem · #5 (**permalink**) 01-24-06, 18:01

theoretically I don't see why not

if your join is correct..
SELECT *FROM data join basket on data.Symbol=basket.symbol WHERE symbol in ("PUB1", "PUB2","PUB3");
give it a whirl and see what happens

jfulton · #6 (**permalink**) 01-24-06, 18:48

Code:

SELECT *FROM data join basket on data.Symbol=basket.symbol WHERE symbol in ("PUB1", "PUB2","PUB3")

Regarding "symbol in...", isn't that "symbol" ambiguous?

Gatta run, but simplest thing I think would be a UNION, no?

harper · #7 (**permalink**) 01-26-06, 18:22

yes it came back with this

#1052 - Column: 'symbol' in where clause is ambiguous

i don't know how to write it using union, i found replacing join with union does'nt work

jfulton · #8 (**permalink**) 01-28-06, 17:14

Code:

SELECT * FROM data WHERE symbol in ("PUB1", "PUB2"...."Pubn")
UNION
SELECT * FROM basket WHERE symbol in ("PUB1", "PUB2"...."Pubn")

Make sure the two queries return the same columns though.

Internet Services

Web Development

Digital Marketing

Consumer Tech