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

R

Rooly2021-03-23 11:40:40

How to properly organize apiResource Laravel? 2Reply

A

Anton Zolotarev2015-04-20 17:51:12

How to make 2 conditions in Apache - Rewrite rule? 4Reply

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

E

Ernest Faizullin2018-12-22 12:19:26

How to install V8.js in WSL subsystem? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question