/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

0 vote206 views1 answer
Connect postgresql using a connection string
SQL
0 vote253 views1 answer
Varchar2 length in oracle
SQL
11 votes273 views1 answer
Oracle insert from select
SQL
0 vote139 views1 answer
How to set field to null in sql
SQL
0 vote176 views1 answer
Sql delete where x or y or z
SQL
0 vote237 views1 answer
Sql to excel pgadmin
SQL
0 vote206 views1 answer
Executescalar in sql server
SQL
1 vote185 views1 answer
Sql delete all values in a column
SQL
0 vote181 views1 answer
Mysql count by month
SQL
16 votes239 views3 answers
Order by sql query
SQL