/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

1 vote165 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
11 votes148 views6 answers
Distinct sql
SQL
1 vote144 views1 answer
Postgres grant read only access to database
SQL
0 vote220 views1 answer
Sql to search who modified
SQL
4 votes148 views4 answers
Oracle tablespace tables list
SQL
0 vote143 views2 answers
How to relationship query two different tables in MySQL
SQL
1 vote159 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote143 views1 answer
How to make case insensitive in sql
SQL
9 votes138 views2 answers
Default number in sql
SQL
0 vote165 views1 answer
Mysql get nth highest
SQL