79247617

Date: 2024-12-03 12:37:33
Score: 0.5
Natty:
Report link

We can do comparison directly by using WHERE clause, try following query:

select 
  (apply_json_data -> 'companyInformation' -> 'operationalAddress' ->> 'state') AS statvalue
from
  sat_application_apply
where 
  (apply_json_data -> 'companyInformation' -> 'operationalAddress' ->> 'state') = 'apple';

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Trushaba B. Jadeja