Hi, normally if I used JSON to store data into the DB I use a query like this:
SELECT ... FROM ... WHERE 'ex' LIKE '%"WHATYOURELOOKINGFOR"%'
It works perfectly even in tables with thousands of rows, but I search the exact string.
In other cases I agree with jwmcpeak: using a regex with JSON could be a very slow solution.
I suggest to use a dedicated DB table.