/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 vote179 views1 answer
Oracle sql replace string in clob
SQL
0 vote255 views1 answer
Max length found in mysql
SQL
2 votes250 views2 answers
Sql percentage
SQL
8 votes238 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote228 views1 answer
Call function sql oracle
SQL
0 vote219 views1 answer
Oracle sql date summer time
SQL
0 vote231 views1 answer
Add alternate add column sql
SQL
0 vote235 views1 answer
Oracle sql generate list of days
SQL
0 vote248 views1 answer
Sql drop procedure if exists
SQL
2 votes237 views2 answers
Sql query to list all tables in a database sql server
SQL