/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 vote355 views1 answer
Prisma transaction
SQL
0 vote331 views1 answer
Plpgsql raise notice
SQL
0 vote312 views1 answer
Mysql auto increment default value with prefix month and year
SQL
12 votes328 views4 answers
Mysql ifnull
SQL
2 votes329 views5 answers
SQL trigger
SQL
0 vote316 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote322 views1 answer
How to close external sql connection in laravel
SQL
19 votes302 views1 answer
Sqrt(-1)
SQL
5 votes317 views3 answers
Day of week postgresql
SQL
2 votes324 views1 answer
Oracle list grants on package
SQL