MySQL Select Multiple VALUES

Question

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

Answer 1

Try or:

WHERE id = 3 or id = 4

Or the equivalent in:

WHERE id in (3,4)

Answer 2

Try this -

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