/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

-1 vote131 views3 answers
How to restart mysql in linux
SQL
0 vote135 views1 answer
Logtash mysql cofiguration file
SQL
0 vote145 views1 answer
T-SQL Create Trigger
SQL
4 votes130 views1 answer
Sql delete multiple conditions
SQL
0 vote135 views1 answer
Import mysql'
SQL
5 votes138 views3 answers
Mysql remove unique constraint
SQL
0 vote129 views1 answer
Postgres populate table from another table
SQL
2 votes178 views1 answer
Orcale index size
SQL
0 vote138 views1 answer
Add super privilege mysql
SQL
0 vote131 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL