/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 vote337 views1 answer
Change magento database url usimg musql
SQL
0 vote321 views1 answer
Use between operator in mysql
SQL
3 votes357 views1 answer
Oracle list privileges
SQL
0 vote332 views1 answer
Calculate date and convert to yearsmysql
SQL
3 votes352 views1 answer
APEX elapsed time
SQL
0 vote331 views2 answers
Select index table oracle
SQL
-1 vote312 views1 answer
How to use update trigger in sql
SQL
0 vote331 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
4 votes329 views3 answers
Postgres set default value
SQL
2 votes368 views3 answers
Mysql kill
SQL