JSON_SEARCH and Regex in mysql

Question

My JSON looks like

user1--> 
{"feeds": [{"trait": "ms", "rating": "5", "observation": "fstress", "riskscaling": "3"}, {"trait": "es", "rating": "7", "observation": "abcde", "riskscaling": 6}], "ad_countryCode": "91"}

If I want to find value for a user having fstress then I am using query as-

SELECT DISTINCT globalusers.id 
FROM globalusers 
WHERE (JSON_SEARCH(dynamic_attributes->>'$.feeds[*].observation','all', 'fstress'));

then I am getting my user id but now I want to use regex to find user having {fstress} Any one help?

care to give an example for such a user?

Skeeve
– Skeeve

2021-04-16 05:31:59 +00:00
Commented Apr 16, 2021 at 5:31 — Skeeve
– Skeeve, Commented Apr 16, 2021 at 5:31

Jasonred8 · Accepted Answer · 2021-04-16 05:33:49Z

3

Just include the string fstress ?

SELECT globalusers.id FROM `globalusers ` WHERE address REGEXP 'fstress';

answered Apr 16, 2021 at 5:33

Jasonred8

9226 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Apurva Over a year ago

This qry worked for me-->SELECT globalusers.id FROM globalusers WHERE dynamic_attributes->>'$.feeds[*].observation' REGEXP 'fstress';

Apurva · Accepted Answer · 2021-04-16 06:03:42Z

0

Working Qry for the same--> SELECT globalusers.id FROM globalusers WHERE dynamic_attributes->>'$.feeds[*].observation' REGEXP 'fstress';

answered Apr 16, 2021 at 6:03

Apurva

151 silver badge4 bronze badges

Collectives™ on Stack Overflow

JSON_SEARCH and Regex in mysql

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related