" /> Password <br /><input type="password" name="passwd" id="passwd" class="inputbox" size="18" alt="password" />
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

 
+1 #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
 
 
-11 #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
 
 
+1 #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
 
 
+7 #4 sonyPlaystation 2011-02-09 12:30 Dimchik, the query will return both, taking into materiel on the algebra of logic! Quote
 
 
+5 #5 Max 2011-02-11 13:31 Soglasen ... protection and 'Hansen' and 'Pettersen'. Zrya cheloveka offended))) Quote
 
 
+1 #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
 
 
0 #8 nighting 2012-04-02 00:27
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
)






SELECT `id`, `nazva_tov`, `signature`, `najavnist`, `` china
FROM `product`
WHERE id
IN (

FROM `tovar_na_zamov l`
WHERE tovary_id = 2
)
LIMIT 0 , 30 Quote
 

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Advertisement
© 2009 ageent.ru.