[RESOLVED] filter results based on a key inside a json string in text column

[bike5]

Is there a way for me to filter out results based on a value inside a text column when the value is a json string.

Ex: {"test1":"hello","test2":"world"}

Say I want to filter my query saying I want all results where "test2" is LIKE "%orld%". Basically use the LIKE but inside a json string. Is this possible?

-Thanks

[bike5]

I have been working on this regex and it seems to be working but is there a better way to write this?

the "(orld)" is the actual search

SELECT FROM tablename WHERE param REGEXP '"test2":"([[:alnum:]]|[[:digit:]]|[[:blank:]])(orld)+([[:alnum:]]|[[:digit:]]|[[:blank:]]])*"'

I want to query to be able to search any character the user types in, not sure what combination of characters classes for mysql I would need to include other symbols and such. Anyone written a better regex for this?