/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

2 votes167 views2 answers
How to check data type in sql server
SQL
1 vote151 views1 answer
Postgres format date in select
SQL
0 vote138 views1 answer
Mysql two joins
SQL
0 vote143 views1 answer
Setval postgres example table id
SQL
1 vote137 views1 answer
Psql lst trigger
SQL
0 vote146 views2 answers
SQL FROM
SQL
1 vote145 views2 answers
Mysql remove first and last character from string
SQL
13 votes133 views2 answers
Sqlite rename column
SQL
1 vote137 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
11 votes127 views2 answers
Having clause
SQL