/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

3 votes142 views2 answers
Mysql time
SQL
0 vote118 views1 answer
Sql injection mitigation
SQL
0 vote140 views1 answer
Sql developer search all packages for text
SQL
1 vote153 views2 answers
Sql insert timestamp
SQL
0 vote252 views1 answer
Mysql edit trigger
SQL
0 vote201 views1 answer
Scheduled mysql database backup in linux
SQL
2 votes140 views2 answers
Created at and updated at in mysql
SQL
27 votes142 views5 answers
Add column in table
SQL
-1 vote93 views2 answers
Datetime sql server week
SQL
0 vote107 views1 answer
Connection error in mysql workbench
SQL