/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

1 vote247 views2 answers
Create a unqie constraint mysql
SQL
-1 vote255 views1 answer
Ssql to lowercqse
SQL
0 vote257 views1 answer
Sql server port 1434
SQL
0 vote241 views1 answer
Access refused mysql xampp server
SQL
21 votes273 views3 answers
Sql server search column name in all tables
SQL
0 vote261 views1 answer
Oracle current timestamp insert statement
SQL
1 vote282 views1 answer
Oracle see column type
SQL
3 votes276 views1 answer
Mysql insert on dupèlicate
SQL
17 votes249 views5 answers
Order by sql
SQL
0 vote256 views1 answer
How to display value of variable in mysql
SQL