[rosslyn]

Hi,

THis is a very basic question, but I can't remember how to write the statement for MySQL.

I'd like to query my MySQL database, table XYZ, and retrieve all records with id = 1, 20, 15, 7, and 3. In psuedo-code it might look like:

select * from XYZ where id = [1,20,15,7,3]

What would this query look like for a MySQL database?

Thanks

-R

[rosslyn]

Sorry for such a silly question. I fiddled around with the code and realized that this worked just fine:

select * from XYZ where id = (1,20,15,7,3)

Thanks for your patience.

-r

[Arkham_c]

Originally posted by rosslyn:
Sorry for such a silly question. I fiddled around with the code and realized that this worked just fine:

select * from XYZ where id = (1,20,15,7,3)

Thanks for your patience.

-r

That's not really correct SQL syntax. It may have worked, but the correct form would be:

Code:

SELECT * FROM XYZ WHERE id IN (1,20,15,7,3)