sqlmysqlselect

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

Solution

  • Try or:

    WHERE id = 3 or id = 4

    Or the equivalent in:

    WHERE id in (3,4)