SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table User(userDetails text);
✓
insert into User values
('{"id":"77","uid":"247","email":"abc@xyz.com"}'),
('{"id":"78","uid":"248","email":"def@xyz.com"}'),
('{"id":"79","uid":"249","email":"ghi@xyz.com"}');
✓
select * 
from user
where json_extract(userDetails, '$.uid') = '247'

{
  "code": "SQLITE_ERROR"
}


select * 
from user
where ',' || replace(replace(replace(userDetails, '{', ''), '}', ''), ' ', '') || ',' like '%,"uid":"' || '247' ||'",%'


userDetails


{"id":"77","uid":"247","email":"abc@xyz.com"}