Question about search mysql

by YongC
0 replies
  • WEB DESIGN
  • |
Hi guy !
In my database i have two table Product and ProductField

Here is my table product :
ProductID,ProductName,Date,Price
Example i have two product

1,Iphone 5, 05/12/1016,500
2,Iphone 6, 05/12/1016,800

And here is my table productfield
ProductID,FieldName,Data
And here is the example data

2,Color,Pink
2,Ram,16gb
1,Color,Silver
1,Ram,32gb

And my question is how i selec an iphone with color pink and ram 16gb ?
#mysql #question #search

Trending Topics