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