I am storing destinations
field as json
type in mysql
example column value ["Goa", "Moonar", "Kochi"]
I would like to get all rows that matches goa
as destinations
However this row query returns the desired result
SELECT * FROM `packages`
WHERE JSON_CONTAINS(destinations, '["Goa"]');
But what is the eloquent equivalent of the above query??
Laravel version 5.3
Modelname :Search
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire