How to search in Mysql by json field, by array?

A

A

Alexander2017-10-12 11:03:06

MySQL

Alexander, 2017-10-12 11:03:06

How to search in Mysql by json field, by array?

How to search by fields like ['1','2','3']
Let's say I need to select 1 field wherever the second field has the number 60, and the third has 80:
prntscr.com/gweb4r
In the database, the fields have the json type

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexey Ukolov, 2017-10-12
@alexey-m-ukolov

https://dev.mysql.com/doc/refman/5.7/en/json-search...

Similar questions

M

matros972017-04-20 10:07:09

The text does not fit into the block? 4Reply

T

Timofey Belousov2015-05-12 23:15:48

Where and how to convert a png file to cur? To set the cursor on the site? 5Reply

R

Rostyk Ice2015-05-16 22:23:57

How to restore scripts in Tampermonkey with only the old Chrome folder? 3Reply

R

Roma Kotolup2021-04-28 13:25:11

How to remove shortcut in windows? 4Reply

N

NooBick2019-11-09 23:24:47

Question about requests.post, how to do data correctly? 5Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question