[mysql] MySQL Select Multiple VALUES

Totally out of ideas here, could be needing a simple solution.

Basically my desired query is :

SELECT * FROM table WHERE id = 3,4

I want to select only the row which has ID 3 and 4, or maybe name "andy" and "paul"

Thank you very much for the answer

Try this -

 select * from table where id in (3,4) or [name] in ('andy','paul');