/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

4 votes122 views2 answers
Show all database inside postgresql
SQL
0 vote126 views1 answer
Mysql streaming example
SQL
0 vote120 views1 answer
How to find columns with null values in sql
SQL
8 votes107 views3 answers
Mysql alter table add index
SQL
0 vote107 views1 answer
Sql select merge multiple values
SQL
0 vote120 views3 answers
Database restoring error
SQL
7 votes114 views1 answer
Postgres base size
SQL
0 vote123 views4 answers
Restart MySQL
SQL
15 votes109 views4 answers
T-sql drop function if exists
SQL
0 vote118 views1 answer
Oracle sql number to varchar2
SQL