How to perform JSON searches created with MySQL

1

I have to do a lot of searches in a SQL table, so it occurred to me to do 1 single selected query and save it in a JSON like this:

SELECT json_object('id', Id, 'nombre', nombre) FROM etiquetas

What I do not know, is how to search inside that JSON (if it is possible) and if I am doing the right thing or the most convenient thing is to do the sql query loop. Thanks!

    
asked by Patricio 14.09.2018 в 03:08
source

0 answers