/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

36 votes185 views3 answers
Finding duplicate column values in table with sql
SQL
1 vote137 views1 answer
Oracle character set
SQL
0 vote203 views1 answer
Running percentage of total postgres
SQL
0 vote222 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote165 views1 answer
How to get initials in sql
SQL
0 vote182 views1 answer
Sql column contains special character
SQL
0 vote216 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote178 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote214 views1 answer
Sqlite unique multiple columns
SQL
0 vote185 views1 answer
Incorrect string value: mysql
SQL