/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

7 votes174 views2 answers
Mysql db size
SQL
0 vote209 views1 answer
Use mysql in java program
SQL
10 votes170 views1 answer
Dba_dependencies
SQL
1 vote166 views1 answer
Mysql current time
SQL
0 vote191 views1 answer
Sql date time query find
SQL
0 vote170 views1 answer
Syntax for changing column size in mysql
SQL
3 votes178 views1 answer
Oracle apex call duration
SQL
1 vote191 views2 answers
Find nth highest salary of an employee
SQL
3 votes198 views3 answers
1396(hy00) mysql error
SQL
7 votes191 views5 answers
Max 3 salary in sql
SQL