Welcome Guest, Not a member yet? Register   Sign In
advanced myslq query
#1

[eluser]abada[/eluser]
hi all

table colors

--------------
id name
--------------
1 red
2 blue
3 green
4 black
5 yellow
--------------

table tshirts
------------------------
id name colors
------------------------
1 tshirt1 1,2
2 tshirt2 1,3,5
3 tshirt3 1,4,5
4 tshirt4 3,4,5
5 tshirt5 1,2,3,4,5
----------------------------

how can i get tshirts which have
case 1:
colors (1,3)
and i want return only tshirt2,tshirt5

case 2:
colors (1,2,3,4,5)
and i want return only tshirt5

case 3:
colors (4,5)
and i want return only tshirt3,tshirt4,tshirt5


thanks


Messages In This Thread
advanced myslq query - by El Forum - 11-04-2010, 02:05 AM
advanced myslq query - by El Forum - 11-04-2010, 02:18 AM
advanced myslq query - by El Forum - 11-04-2010, 02:56 AM
advanced myslq query - by El Forum - 11-04-2010, 06:45 AM
advanced myslq query - by El Forum - 11-04-2010, 06:21 PM
advanced myslq query - by El Forum - 11-04-2010, 07:11 PM
advanced myslq query - by El Forum - 11-07-2010, 01:28 AM
advanced myslq query - by El Forum - 11-07-2010, 03:03 AM



Theme © iAndrew 2016 - Forum software by © MyBB