/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 votes200 views2 answers
How to run postgresql in linux
SQL
50 votes265 views4 answers
Sql alter type of column
SQL
2 votes314 views1 answer
Mysql create user with remote access
SQL
0 vote200 views1 answer
Clone table structure mysql
SQL
2 votes217 views2 answers
How to add not null constraint in sql
SQL
0 vote236 views1 answer
Postgresql remove new line from string
SQL
4 votes272 views4 answers
Update select mysql
SQL
0 vote259 views1 answer
How to check event scheduler status mysql
SQL
3 votes254 views1 answer
Oracle apex warn on unsaved changes
SQL
1 vote198 views1 answer
Oracle turn off constraint
SQL