Is there a way to implement condition/search on metadata(json) stored as a string in mysql query

On By admin

i want to fetch results according to columns stored in metadata column…where json data is stored as string I want to implement this in sql query itself meta data after parsing:- “metadata”: { “file”: “https://ipfs.io/ipfs/QmctyySWTJtLGDjCQkDd7N9DjhpY9ffvmPZ8JiYm1Y9t1a”, “putOnMarketplace”: true, “fixedPrice”: { “price”: 0.1, “currency”: “”, “name”: “Tester colectibles 2”, “description”: “scs”, “royalties”: […]