I've got a bizarre setup I am working with where, I have a table with multiple columns. One of the columns, I'll call it "weird-column" has data type of text **but** the information that is stored *within* that column appears to be listed as JSON.

"Why wasn't this column data type set as JSON or JSONB?" No idea - this is a DB that I was given to work with.

Example:

```
{
  "id": "numbers-and-letters-go-here":[
    {
      "Code": "thing"
    }
  ],
  "issuedt": "03/18/1989",
  "expirationdate": "03/18/3089",
  "firstname": "Funky",
  "middlename": "Cold",
  "lastname": "Medina"
}

```

Now, I need to compare dates stored *within* weird-column, to see if any expriationdate expire *before* issuedt. I need to do this for **every entry** in weird-column and see output for the entries for each record which expired before it was even issued.

My initial plan was to use something like

```
select * from table_1
where issuedt < expriationdate

```

but since all of this is data stored *within* weird-column, that wouldn't work. Is there a way to specify this? Something like

```
select * from table_1
where weird-column.issuedt < weird-column.expriationdate

```

I don't have the knowledge to describe what it is that I need to do, but have a vague understanding of what I need done. Any suggestions at all would be extremley helpful.