/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

5 votes351 views1 answer
Mysql change primary key
SQL
0 vote400 views1 answer
T-sql delete view if exists
SQL
8 votes360 views2 answers
Python simple connect to mysql
SQL
7 votes363 views6 answers
Group_concat in mysql
SQL
22 votes348 views4 answers
Show list of users in mysql
SQL
11 votes375 views1 answer
Sql query to find duplicates in column
SQL
0 vote349 views1 answer
How to save data in database in mysql node
SQL
0 vote349 views1 answer
Oracle c# multiple update sql
SQL
13 votes357 views6 answers
Restart postgresql
SQL
7 votes372 views1 answer
Sql limit decimal places
SQL