/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 vote134 views2 answers
Update query with between in mysql
SQL
1 vote118 views1 answer
Oracle difference between two dates in years
SQL
1 vote164 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
19 votes125 views5 answers
Display table in sql
SQL
1 vote128 views1 answer
Add sequence postgres
SQL
3 votes121 views2 answers
Sqlite print all column names
SQL
0 vote120 views1 answer
Postgresql default value boolean
SQL
0 vote129 views1 answer
Query to remove duplicate rows from a table
SQL
17 votes135 views6 answers
MySQL ORDER BY
SQL
0 vote114 views1 answer
How many columns can be used for creating index?
SQL