/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

2 votes282 views2 answers
Mysql user access to database
SQL
0 vote296 views1 answer
Mssql dockere
SQL
1 vote278 views2 answers
Mysql error 1215
SQL
3 votes290 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote246 views1 answer
Sql runnignsum
SQL
24 votes263 views5 answers
Sql reset auto increment
SQL
0 vote275 views1 answer
Syntax for changing column size in mysql
SQL
0 vote282 views1 answer
Mysql min value row
SQL
3 votes296 views1 answer
Sql case update
SQL
0 vote278 views1 answer
Install sql server windows 10
SQL