/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

8 votes237 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote235 views1 answer
Mysql root permission denied lost
SQL
36 votes226 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote226 views1 answer
Snap craft
SQL
0 vote232 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote284 views1 answer
Redshift running queries
SQL
0 vote228 views1 answer
Sql server beginning of month
SQL
0 vote219 views1 answer
Oracle create package specification
SQL
0 vote248 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
4 votes224 views4 answers
Sqlite describe table
SQL