/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 vote300 views1 answer
Mysql:5.6 syntax create table
SQL
2 votes324 views1 answer
Mysql sysdate - 1 day
SQL
0 vote367 views1 answer
Dockerfile example for Django
SQL
0 vote314 views1 answer
Sql contains vs like
SQL
0 vote332 views1 answer
Sql delimiter to columns
SQL
5 votes305 views2 answers
Mysql drop table cascade
SQL
0 vote267 views1 answer
Oracle sysdba connect as another user
SQL
0 vote263 views1 answer
Online sql compiler
SQL
1 vote325 views2 answers
Sql server add time to date
SQL
2 votes358 views1 answer
Oracle run_duration to number
SQL