I have innodb table with a column in JSON format
My table products:
id_products int
name_products varchar --> fx-6350<br>
feature_products json --> {"cache":{"l1":"128k","l2":"6Mb","l3":"8Mb"},"frequency":"3.9GHz","socket":am3+"}
How can I make a query with result "frequency" and "3.9GHz" and query for everything?
Best Answer
If I've understood you correctly, you want something like this
I created a table "products" - note that the last record corresponds to the one we want.
Running the query above
gives:
Which, as we can see, is what was required -
result "frequency" and "3.9GHz" and query for everything
I found this reference helpful. And, if all else fails, one can always consult the documentation here :-). Also, the MySQL server team blog was useful.