mercredi 6 mars 2019

How to perform select operation in between comma seperated input string and comma seperated string in table attribute in MySQL

I am doing a project in Larvel 5.7.So i need to perform a search operation regarding amenities.But the problem is amenities filter inputs are multiple like as ('1,2,4 ').So i need to fetch All 'hotel' with amenities (1 or 2 or 1,2). I could not get the answer by using find_in_set() and whereIn().so please help me to write a select query in laravel 5.7. Thanks

This is my table - hotel

id     name    amenities
*************************
1      Abad     1,2,3,4
2      Taj      2,3
3      Marina   1,5,4
4      sealord  2
5      ceylon   3,1 



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire