SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete create table contacts ( id int, contact_data jsonb ); insert into contacts values (1, '{ "tags": [ "MOCK_DATA (4)" ], "Email": "nk3ynman5@marriott.com", "reach": false, "Gender": "Male", "Interest": [ "Dance" ], "Last Name": "Kynman", "First Name": "Nicko" }'), (2, '{ "ltv": "6", "City": "Bengaluru", "Email": "aaa@aa.com", "State": "Karnataka", "Country": "India", "latitude": 12.9715987, "Last Name": "World", "longitude": 77.5945627, "First Name": "Helo" }'), (3, '{ "ltv": "11", "Email": "sf3ortye8@ebay.co.uk", "reach": false, "Gender": "Female", "Country": "United States", "latitude": "37.09024", "Last Name": "Fortye", "longitude": "-95.712891", "First Name": "Sissie" }'); SELECT * from contacts; SELECT id from contacts where ( contact_data->> 'ltv' > '2' and contact_data->> 'ltv' < '9' ); SELECT id from contacts where ( contact_data->> 'ltv' > '2' and contact_data->> 'ltv' < '12' );