/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 vote183 views1 answer
Sqlcl format
SQL
16 votes182 views1 answer
Mssql int max value
SQL
1 vote204 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote188 views1 answer
Create table sql generator
SQL
-1 vote206 views2 answers
Sql search all tables for attributes
SQL
4 votes238 views4 answers
Check constraint in ms sql
SQL
0 vote172 views1 answer
Postgresql regular expression special characters
SQL
1 vote197 views1 answer
Postgresql not in
SQL
5 votes185 views1 answer
Sql add column after another
SQL
1 vote184 views1 answer
Mysql batch insert
SQL