jeudi 7 juillet 2016

mysql query to find price between size string attribute


In my table product size (width*hieght) will saving as below format

 ID    size      Price
    1   10*12     100 
    2   22*28     200 
    3   32*38     300 

When a User will search a product with width 20 & height 25 ,Then i need to get price of 200 second row of table . Please help me to write a mysql query for this.


Aucun commentaire:

Enregistrer un commentaire