/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 vote278 views1 answer
Sql server select top 2 of each group
SQL
0 vote285 views1 answer
Sql anywhere create procedure
SQL
0 vote271 views1 answer
SQL get max per id
SQL
1 vote268 views1 answer
Mysql show data from table
SQL
5 votes350 views3 answers
Create function in postgresql
SQL
0 vote299 views2 answers
Oracle create tablespace autoextend
SQL
1 vote296 views1 answer
Mysql strict_trans_tables
SQL
0 vote299 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
1 vote285 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote293 views1 answer
Select from column mysql
SQL