/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 vote231 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote194 views1 answer
Inner joint
SQL
1 vote204 views2 answers
Oracle replace
SQL
0 vote366 views1 answer
Running mysql from bash sc
SQL
-1 vote205 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote196 views1 answer
Firebird where
SQL
1 vote193 views1 answer
Right outer vs left outer join
SQL
0 vote226 views1 answer
Database db connection string format
SQL
0 vote200 views1 answer
Add sqlite3 in lumen
SQL
0 vote209 views1 answer
Psql check table fields
SQL