Use LIKE statement in a json type column

Asked Sep 08 '20 at 21:08

Active Sep 08 '20 at 21:56

Viewed 31 times

I have a table with some columns arraged kinda like this:

Column a (type: INT)
Column b (type: TINYINT)
Column c (type: INT)
Column d (type: TEXT)
Column e (type: JSON)

I want to retrieve columns a b and c where the column e has the value x somewhere in the list. I'm using this command: SELECT a, b, c FROM table WHERE e LIKE x; The problem is even if the value is there, the result from this query is []. What am I doing wrong?

Edit: Made it work by going to this thread: How can write queries in MySQL that can parse JSON data in a column?

edited Sep 08 '20 at 21:56

O. Jones

103,626
17
118
172

asked Sep 08 '20 at 21:08

Lysander12 PT

https://stackoverflow.com/questions/29137915/how-can-write-queries-in-mysql-that-can-parse-json-data-in-a-column – Waqas Ghouri Sep 08 '20 at 21:21
what kind of x values are you searching for? what is the structure in the json? – ysth Sep 08 '20 at 21:21
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html#function_json-extract – Waqas Ghouri Sep 08 '20 at 21:21
Show some example data, and actual query *(with an actual value for `x`)* and the actual results you get. – MatBailie Sep 08 '20 at 21:26
https://imgur.com/a/GzZgVg5 – Waqas Ghouri Sep 08 '20 at 21:26

Use LIKE statement in a json type column

0 Answers0