CODEWITHSUNDEEP
mysql
user2755541
user2755541

Reputation: 546

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

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...

Upvotes: 7

Views: 32294

Answers (4)

Tarik
Tarik

Reputation: 11209

SELECT * FROM myTable WHERE myColumn in (resultA, resultB, resultC ....)

Upvotes: 1

keelerm
keelerm

Reputation: 2943

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

Alternatively,

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

Upvotes: 15

9997
9997

Reputation: 1357

This should work.

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

Upvotes: 1

Fabio
Fabio

Reputation: 23510

Don't use WHERE many times, just use OR between your conditions

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

Note that I surrounded your resultX with single quotes assuming they are strings, if they are integers you can omit them

Upvotes: 1

Related Questions