/SQL/Mysql select where field is a value

Mysql select where field is a value

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

-- Alternatively,

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

Source: stackoverflow.com

Similar codes

0 vote140 views1 answer
Sql column as header
SQL
0 vote174 views1 answer
Inner join distinct
SQL
0 vote140 views1 answer
Mysql db dump restore max file size issue
SQL
25 votes154 views6 answers
Import database mysql command line
SQL
0 vote158 views1 answer
Cube oracle
SQL
3 votes151 views2 answers
MySQL query to get column names
SQL
5 votes315 views2 answers
How to ascending order in sql
SQL
0 vote180 views1 answer
Sql filter rows with condition
SQL
0 vote167 views1 answer
How to change the field size of an existing column
SQL
0 vote144 views1 answer
Use mysql in java program
SQL