/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 votes97 views1 answer
Oracle failed login attempts
SQL
1 vote96 views1 answer
Influxdb export to csv
SQL
1 vote99 views1 answer
Oracle list data files
SQL
0 vote103 views1 answer
Inserted row count tsql
SQL
0 vote96 views1 answer
Postgresql remove new line from string
SQL
-1 vote94 views1 answer
How to format tables in sqlplus
SQL
7 votes163 views1 answer
Oracle alter sequence restart start with
SQL
3 votes97 views1 answer
Two selects in one query
SQL
1 vote226 views2 answers
Sql unique rows
SQL
1 vote106 views1 answer
Raise application error in oracle
SQL