to search record based on field (array element)

Muddy Markhor answered on July 18, 2022 Popularity 1/10 Helpfulness 1/10

answer to search record based on field (array element)

Comment

SELECT * FROM mytable WHERE pub_types @> '{"Journal", "Book"}';

Popularity 1/10 Helpfulness 1/10 Language whatever

Tags: field record search whatever

Link to this answer
Share Copy Link

Contributed on Jul 18 2022

Muddy Markhor

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.