mysql select where field is a value

Powerful Penguin answered on October 7, 2021 Popularity 4/10 Helpfulness 1/10

answer mysql select where field is a value

mysql select where field is a value

Comment

SELECT *
FROM myTable
WHERE myColumn = 'resultA' 
   OR myColumn = 'resultB' 
   OR myColumn = 'resultC';

-- Alternatively,

SELECT *
FROM myTable
WHERE myColumn IN ('resultA', 'resultB', 'resultC');

Popularity 4/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: field mysql select sql where

Link to this answer
Share Copy Link

Contributed on Oct 07 2021

Powerful Penguin

0 Answers Avg Quality 2/10

mysql select where field is a value

Contents

More Related Answers

mysql select where field is a value

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.