2023-01-19

sql how to select row based on json format field value?

I have a table ,one of the table filed is json format:

my_table

id  json_field

1   { "to_status": 7, "to_status_name": "In Progress", "role": "admin"}

2   { "to_status": 3, "to_status_name": "Completed", "role": "admin"}

3   { "to_status": 2, "to_status_name": "Completed", "role": "customer"}

How can I select all rows that "to_status" is 3 or 2 ?

Any friend can help?



No comments:

Post a Comment