/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 vote291 views2 answers
Oracle create chain rule
SQL
0 vote319 views1 answer
Oracle list datafiles
SQL
11 votes312 views3 answers
How to get last row of table in sql
SQL
0 vote303 views1 answer
Flask sqlalchemy session delete
SQL
0 vote279 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote299 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote241 views2 answers
Denormalization in sql
SQL
2 votes283 views1 answer
Create table with primary key
SQL
17 votes294 views3 answers
Cast in sql server
SQL
-1 vote281 views1 answer
Mysql coalesce
SQL