/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 vote114 views1 answer
Wordpress sql change site url
SQL
0 vote119 views1 answer
PGSQL dynamic table name
SQL
-1 vote118 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote112 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote114 views1 answer
Declarative base sqlalchemy
SQL
0 vote124 views1 answer
Sql statement show all emails with dome
SQL
2 votes118 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
18 votes133 views2 answers
Sql comments
SQL
1 vote111 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
1 vote110 views1 answer
SQLite order random
SQL