How to find records in a table among JSON arrays?

Question

Laravel

Hello! There is such a record in the database:

How can I select all records that have either 0or or in 1 element3
{"1":["0", "3"]..."3":[....]}

Answer 1

If the database is mysql, you can query the database with JSON_EXTRACT.
But if there is a lot of data in the table, it is better to pull out the filters field into a separate table.
Working with json in mysql
https://dev.mysql.com/doc/refman/8.0/en/json-funct...

Answer 2

MySQL 8.0 can be used for this

Answer 3

select *
  from tbl
  where JSON_CONTAINS(filters, '{"1":["0"]}') = 1
     OR JSON_CONTAINS(filters, '{"1":["3"]}') = 1

example on dbfiddle
works since MySQL 5.7