Skip to content
Advertisement

How can I find a record that equals a value inside a JSON array

I have the following Table mytable

I’m trying to query where id = 2 and partNum = 2423

Here is what I wrote so far:

What would be the most efficient way to query?

Advertisement

Answer

Here is what worked for me.

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement