/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 vote104 views1 answer
Sql server change schema of a table
SQL
0 vote119 views1 answer
Disable database droping sql
SQL
0 vote149 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote103 views1 answer
Increase speed of like queries postgres
SQL
0 vote113 views1 answer
Trigger stock phpmyadmin output message
SQL
1 vote110 views3 answers
Mysql parse int
SQL
0 vote110 views1 answer
Describe in sqlite3
SQL
1 vote110 views1 answer
Sql select table header
SQL
0 vote106 views1 answer
Sql server concat null
SQL
0 vote96 views1 answer
Strat with in sql
SQL