mySQL query select column where value = a or value = b etc

Question

How do I write a mysql query so that I can select entries under a column that are equal to resultA or resultB or resultC etc.

Something like:

SELECT * FROM myTable WHERE myColumn = resultA OR WHERE myColumn = resultB OR WHERE myColumn = resultC...

Answer 1

SELECT *
FROM myTable
WHERE myColumn = 'resultA' 
   OR myColumn = 'resultB' 
   OR myColumn = 'resultC';

Alternatively,

SELECT *
FROM myTable
WHERE myColumn IN ('resultA', 'resultB', 'resultC');