json-sql-builder2 icon indicating copy to clipboard operation
json-sql-builder2 copied to clipboard

Published 20 hours ago • verified publisher icon planetarydev

MySQL | possible to search JSON values

Open superhero opened this issue 5 years ago • 1 comments

Quick question, do you support a mysql query like this: select * from event where data->"$.foo" = 'bar'

The data column is of type JSON, I tried a few different approaches through the json builder, but no success.

superhero avatar Feb 18 '20 17:02 superhero

I see in the docs that you support this for postgres, but I don't see a solution for mysql. Please let me know your thoughts. Maybe I can help you solve the missing puzzle piece if needed.

superhero avatar Sep 23 '20 15:09 superhero