/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 vote176 views1 answer
Setval in postgres
SQL
0 vote165 views1 answer
Create new schema mysql
SQL
1 vote192 views1 answer
Mysql connect bash
SQL
1 vote179 views1 answer
Importance of comment in mysql
SQL
0 vote163 views1 answer
Bigquery declare
SQL
15 votes178 views3 answers
Find duplicate keys in mysql
SQL
1 vote176 views1 answer
Mysql add fields
SQL
1 vote181 views1 answer
Error code 1175 mysql fix
SQL
1 vote178 views1 answer
Mysql is odd
SQL
-1 vote178 views1 answer
Mysql #1064 error
SQL