Guest User

Untitled

a guest
Apr 26th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. {
  2. fields: [
  3. {
  4. key: 'age',
  5. value: 20
  6. },
  7. {
  8. key: 'years_employed',
  9. value: 10
  10. }
  11. ]
  12. }
  13.  
  14. .find({fields: {$elemMatch: {key:'age', value:20}}})
  15.  
  16. .find({fields: {$elemMatch: {key:'age', value:10}}})
  17.  
  18. {
  19. fields: [
  20. {
  21. key: 'age',
  22. value: 20
  23. },
  24. {
  25. key: 'years_employed',
  26. value: 10
  27. }
  28. ]
  29. }
  30.  
  31. SELECT * FROM `data_table` WHERE JSON_CONTAINS(`data`, '{"key":"age","value":20}', "$.fields")
Add Comment
Please, Sign In to add comment