E-mail Print PDF

IN 

1
2
3

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)

There is a table "Persons":

P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger

For this we use this query:

1
2

SELECT * FROM Persons
WHERE LastName IN ('Hansen','Pettersen')

Query Result:

P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn 10 Sandnes
3 Pettersen Kari Storgt 20 Stavanger

Comments

 
0 #1 Шелест Константин 2010-10-29 18:34 Yet know one way, but it is not so easy to use, it generally is not practical:

SELECT *
FROM Persons
WHERE LastName = 'Hansen' OR LastName = 'Pettersen'

 Quote
 
 
-6 #2 Димчик 2010-11-10 14:13
Yet know one way, but it is not so easy to use, it generally is not practical:

SELECT *
FROM Persons
WHERE LastName = 'Hansen' OR LastName = 'Pettersen'


fuck it, it will return either Hansen or Pettersen and we need both Quote
 
 
0 #3 andy 2010-11-18 21:00 otakvo in good:
SELECT `id`, `nazva_tov`, `signature`, `najavnist`, `` china
FROM `product`
WHERE id
IN (
SELECT tovary_id
FROM `tovar_na_zamov l`
WHERE tovary_id = 2
)
LIMIT 0 , 30 Quote
 
 
+5 #4 sonyPlaystation 2011-02-09 12:30 Dimchik, the query will return both, taking into materiel on the algebra of logic! Quote
 
 
+2 #5 Max 2011-02-11 13:31 Soglasen ... protection and 'Hansen' and 'Pettersen'. Zrya cheloveka offended))) Quote
 
 
0 #6 flash 2011-12-14 12:46 me)? Quote
 
 
0 #7 Dimitri 2012-01-08 23:05
otakvo in good:
SELECT `id`, `nazva_tov`, `signature`, `najavnist`, `` china
FROM `product`
WHERE id
IN (
SELECT tovary_id
FROM `tovar_na_zamov l`
WHERE tovary_id = 2
)
LIMIT 0 , 30




IN (
SELECT tovary_id
FROM `tovar_na_zamov l`
WHERE tovary_id = 2
)



 Quote
 

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Translate

русскийitalianoDeutschEnglishLATVIANукраїнськаfrançaispolski
1

Advertisement


Купить женское белье и магазин нижнего белья. Купить женское нижнее белье подробная статья.

© 2009 ageent.ru.