/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 vote341 views1 answer
Trigger value from maltiple table to single table mysql
SQL
4 votes348 views4 answers
Sqlite describe table
SQL
0 vote360 views1 answer
How to run mysql in git bash
SQL
6 votes352 views2 answers
Database url postgres
SQL
9 votes355 views4 answers
SQL Date Format
SQL
0 vote395 views1 answer
Create user faunadb
SQL
34 votes383 views5 answers
Oracle alter table add column
SQL
1 vote363 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote387 views1 answer
Bigrock database connection string
SQL
0 vote408 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL