/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

7 votes265 views1 answer
Show line number in sql server
SQL
0 vote221 views1 answer
How to execute stored output to csv files
SQL
0 vote214 views1 answer
Postgresql where clause not working
SQL
4 votes217 views3 answers
Oracle sql first day of quarter
SQL
0 vote237 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote225 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
8 votes242 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote240 views1 answer
Cube oracle
SQL
0 vote212 views1 answer
Mysql find missing values
SQL
0 vote219 views2 answers
Sql count number of rows after group by
SQL