Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
D
D
Danil Gaisin2020-08-08 15:48:11
MySQL
Danil Gaisin, 2020-08-08 15:48:11

Mysql json_search how to search json data?

There is a query, in theory it should return films with the "action" genre:

SELECT * FROM `list` WHERE `type` = 'cartoon-series' and JSON_SEARCH(genre, 'one', 'Боевик%') is null

But I get the result in general with other genres.
The column in the database is stored as a json object
spoiler
5f2e9ee1a92da795852667.png

How to search by genre?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
L
Lecturer2020-09-26 22:38:29
How to display search results for sections in wordpress? 5Reply
I
ivanesi2014-05-23 18:39:30
How to dynamically create tables in a database in Django based on a condition? 3Reply
O
oyshomusic2020-10-01 10:45:44
Is it possible to do the following? 3Reply
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
I
Ivan K2018-06-05 15:58:02
Why is openserver dumb on page load? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question