/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 votes215 views2 answers
Sql percentage
SQL
0 vote199 views3 answers
Create and attach user to a postgresql database
SQL
0 vote215 views1 answer
Select milliseconds mysql
SQL
0 vote220 views1 answer
Mysql remove bad character from all fields
SQL
3 votes224 views2 answers
How to force truncate a table in mysql
SQL
0 vote204 views1 answer
Create database store
SQL
1 vote199 views1 answer
Error code 1055
SQL
1 vote215 views1 answer
Sql dcl
SQL
7 votes201 views1 answer
Alter sequence set current value oracle
SQL
0 vote196 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL