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

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": "10",
      "multipleCopies": "",
      "invitationCode": "959671"
    },
    "timedAuction": {
      "price": "",
      "expirationDate": {
        "id": 1,
        "value": "1 Day"
      },
      "name": "",
      "description": "",
      "royalties": "",
      "invitationCode": ""
    },
    "unlimitedAuction": {
      "price": "",
      "name": "",
      "description": "",
      "royalties": "",
      "invitationCode": ""
    },
    "mediaType": "image",
    "type": "fixedPrice",
    "tokenType": "erc721"
  }