/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 vote188 views1 answer
Groupby error in mysql
SQL
3 votes221 views5 answers
No module named 'MySQLdb'
SQL
3 votes205 views2 answers
Truncate table
SQL
1 vote197 views1 answer
Mysql select from outside
SQL
0 vote193 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote186 views1 answer
Update and keep original value sql
SQL
2 votes184 views2 answers
Spring import sql
SQL
0 vote214 views1 answer
Play framework connection via windows sql server
SQL
0 vote203 views1 answer
Enable sql server full text indexing
SQL
22 votes205 views3 answers
Remove all records from table mysql
SQL