Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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');
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql update sequence with order by 
Sql :: ms sql convert hijri to gregorian 
Sql :: subquery aggregation 
Sql :: like in openquery 
Sql :: sql server import json 
Sql :: update or delete on table "model" violates foreign key constraint 
Sql :: oracle date summer time 
Sql :: SQLSTATE[HY000] [1298] Unknown or incorrect time zone 
Sql :: SQL DROP TABLES EVENT 
Sql :: sqlc yml settings version 1.14 
Sql :: mysql a from on this page has 
Sql :: how to make oppointment table in database 
Sql :: what is database username and password in mysqliconnect 
Sql :: truncate syntax in sql 
Sql :: http://localhost:9200/_cluster/allocation/explain 
Sql :: http://challenge01.root-me.org:58036/wsasd 
Sql :: joins and views sql 
Sql :: could not find driver (SQL: PRAGMA foreign_keys = ON;) larave 
Sql :: sql comparison operators 
Sql :: python sqlalcahmey compare datetime using AND_ or OR_ 
Sql :: ltrim entire column sql select query 
Sql :: check sql query executed wp 
Sql :: closure in sql 
Sql :: least orders 
Sql :: plsql check for string in numeric 
Sql :: oracle sql how to overcome 999 limit for IN 
Sql :: how to compile a function in oracle 
Sql :: get who is hired in february in sql 
Sql :: SQL Cut part string 
Sql :: ora 00001 error catch plsql 
ADD CONTENT
Topic
Content
Source link
Name
1+3 =