/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 votes151 views2 answers
Select multiple tables mysql
SQL
6 votes158 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote165 views1 answer
Mysql change timestamp on update
SQL
0 vote182 views1 answer
Oracle decode
SQL
0 vote147 views1 answer
Parsing float to int in mysql
SQL
0 vote195 views1 answer
Drop domain postgresql
SQL
0 vote147 views1 answer
Mysql undo delete
SQL
1 vote164 views2 answers
Insert sqlite
SQL
1 vote160 views1 answer
How to check the mysql version mac
SQL
11 votes180 views4 answers
Reset identity column values in sql server
SQL