Does the json contain a word?

N

NubasLol2019-09-10 15:31:18

PostgreSQL

NubasLol, 2019-09-10 15:31:18

An example value in a json column, how can I check if it contains the string 'closed'.
["new", "verified"]
Tried using ::jsonb ? but getting problems with laravel substitution instead of asking value

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

K

Kamil2020-03-19 10:33:29

How to extract information from habr? 3Reply

E

Evgeny Emelyanov2017-09-28 14:30:42

How to restore PostgreSQL databases from old DATA folder? 1Reply

B

BonBon Slick2017-10-02 21:56:04

How to import data if PhPPgAdmin hangs and gives errors when importing into the database "The connection was reset."? 0Reply

M

MarkusEfr2020-02-22 11:40:39

How to select data from JSON in Postgresql? 2Reply

O

Oleg Petrov2017-10-06 10:29:13

How to get more characters in a cell when querying? 1Reply

Didn't find what you were looking for?

Ask your question